<%@ include file="left.jsp" %>
|
|
<%
if ( mstate.equals("CA") ) {
%>
|
Monthly Payment Calculator
Provided by Loan MAX
|
|
(949) 733-0570 Email
|
|
|
|
<%@ include file="/others/calculators/MonthlyPayment_include.jsp" %>
|
|
|
|
|
<%
}
%>
<% if (welagent.equals("Y")) { %>
| Welcome agents. |
<% } else if (welagent.equals("N")) { %>
No agents, Please. |
<% } %>
|
|
| Listing No : <%= listno %> |
|
Print this page |
<% if (showemail.equals("Y")) { %>
| <%= contname %> <%= contlast %> |
<% } else { %>
<%= contname %> <%= contlast %> |
<% } %>
|
<%
if (!mainpict.equals("null") ) {
%>
 |
<%
} else {
%>
|
<%
}
%>
| <%= maddress %> |
|
| <%= mcity %> , <%= mstate %> <%= mzip %> |
|
|
<% if (showcont.equals("Y")) { %>
| <%= contphone %> ext.<%= cextphone %> |
<% } %>
| Map |
|
|
| Selling Price : <%= tprice %>
|
|
| Community : <%= neighbo %>
|
|
| School District : <%= schdist %>
|
|
| Property Type :
<% if ( typeprop.equals("1") ) {
%>
Townhouse
<%
} else if ( typeprop.equals("2") ) {
%>
Condo
<%
} else if ( typeprop.equals("3") ) {
%>
Single
<%
} else if ( typeprop.equals("4") ) {
%>
2 Unit
<%
} else if ( typeprop.equals("5") ) {
%>
3 Unit
<%
} else if ( typeprop.equals("6") ) {
%>
4 Unit
<%
} else if ( typeprop.equals("7") ) {
%>
Apartment
<%
} else if ( typeprop.equals("8") ) {
%>
Land
<%
}
%>
|
|
|
| Number of Floor : <%= tfloor %>
|
|
Number of Garage : <%= tgar %>
|
|
| Number of Bedroom : <%= tbed %>
|
|
Square Footage : <%= ttotsqu %>
|
|
| Number of Bathroom : <%= tbath %>
|
|
Year Built : <%= tyrbuilt %>
|
|
| Number of Fireplace : <%= tfire %>
|
|
| |
|
<%
String temp_garage = "";
if ( tgarage.equals("1") ) {
temp_garage = "Built in";
} else if ( tgarage.equals("2") ) {
temp_garage = "Free Standing";
} else {
temp_garage = "";
}
String temp_heat = "";
if ( theat.equals("1") )
temp_heat = "Standard Electric";
else if ( theat.equals("2") )
temp_heat = "Electric Heat Lamp";
else if ( theat.equals("3") )
temp_heat = "Standard Gas";
else if ( theat.equals("4") )
temp_heat = "Gas Heat Lamp";
else if ( theat.equals("5") )
temp_heat = "Forced Air Heating";
else if ( theat.equals("6") )
temp_heat = "Fireplace";
else if ( theat.equals("7") )
temp_heat = "Oil";
else if ( theat.equals("8") )
temp_heat = "Wood Burning Stove";
else if ( theat.equals("9") )
temp_heat = "Solar";
else if ( theat.equals("10") )
temp_heat = "Water Boiler";
else
temp_heat = "";
String temp_sewer = "";
if ( tsewer.equals("1") ) {
temp_sewer = "City Provided";
} else if ( tsewer.equals("2") ) {
temp_sewer = "Septic Tank";
} else {
temp_sewer = "";
}
String temp_cool = "";
if ( tcool.equals("1") )
temp_cool = " Central A/C";
else if ( tcool.equals("2") )
temp_cool = "Gas";
else if ( tcool.equals("3") )
temp_cool = "Electric Heat Pump";
else if ( tcool.equals("4") )
temp_cool = "Gas Heat Pump";
else if ( tcool.equals("5") )
temp_cool = "Evaporator";
else if ( tcool.equals("6") )
temp_cool = "Wall Unit";
else
temp_cool = "";
%>
| Type of Garage : |
<%= temp_garage %> |
| Type of Heating System : |
<%= temp_heat %> |
| Type of Sewer System : |
<%= temp_sewer %> |
| Type of Cooling System : |
<%= temp_cool %> |
| |
|
| Other Features : |
<%
if ( hpool.equals("Y") ) {
%>
Pool,
<%
}
if ( hjacuzzi.equals("Y") ) {
%>
Jacuzzi,
<%
}
if ( hbasement.equals("Y") ) {
%>
Basement,
<%
}
if ( htennisco.equals("Y") ) {
%>
Tennis Court
<%
}
%>
<%
if ( hpatio.equals("Y") ) {
%>
Patio,
<%
}
if ( hbalcony.equals("Y") ) {
%>
Balcony,
<%
}
if ( halarm.equals("Y") ) {
%>
Alarm/Security,
<%
}
if ( hwoodflr.equals("Y") ) {
%>
Hardwood Floor
<%
}
%>
<%
if ( haircond.equals("Y") ) {
%>
Air Conditioning,
<%
}
if ( hdwasher.equals("Y") ) {
%>
Dishwasher,
<%
}
if ( hwoodflr.equals("Y") ) {
%>
Disposal
<%
}
%>
|
| |
|
<%
if (!pict1.equals("") || !desc1.equals("") ) {
%>
| <%= nampict1 %> |
| Description : |
| <%= desc1 %> |
|
|
<%
if ( pict1.length() > 0 ) {
%>
<%
}
%>
|
<% } %>
<%
if (!pict2.equals("") || !desc2.equals("") ) {
%>
| <%= nampict2 %> |
| Description : |
| <%= desc2 %> |
|
|
<%
if ( pict2.length() > 0 ) {
%>
<%
}
%>
|
<% } %>
<%
if (!pict3.equals("") || !desc3.equals("") ) {
%>
| <%= nampict3 %> |
| Description : |
| <%= desc3 %> |
|
|
<%
if ( pict3.length() > 0 ) {
%>
<%
}
%>
|
<% } %>
<%
if (!pict4.equals("") || !desc4.equals("") ) {
%>
| <%= nampict4 %> |
| Description : |
| <%= desc4 %> |
|
|
<%
if ( pict4.length() > 0 ) {
%>
<%
}
%>
|
<%
}
} else {
%>
The listing no. does not exist.
Please try again.
<%
}
rset.close();
stmt.close();
/* ------------------- record the page counter ---------------------------------------------- */
/*
PreparedStatement pstmtcn = conn.prepareStatement (
" Update countfreelist " +
" set totfreelist = totfreelist + 1 " );
pstmtcn.executeUpdate();
conn.commit();
pstmtcn.close();
int isvalid = 0;
sql = " select count(id) "
+ " from countselect where id = "
+ id;
// out.println(sql);
Statement stmtval = conn.createStatement ();
ResultSet rsetval = stmtval.executeQuery (sql);
if (rsetval.next()) {
try {
isvalid=rsetval.getInt(1) ;
} catch(Exception e) {
System.out.println("Exception(select,qry):"+e);
}
}
rsetval.close();
stmtval.close();
if ( isvalid > 0 ) {
PreparedStatement pstmtval = conn.prepareStatement (
" Update countselect " +
" set totalcount = totalcount + 1, " +
" selectype = '2' " +
" where id = ? " );
pstmtval.setInt(1,id);
pstmtval.executeUpdate();
conn.commit();
pstmtval.close();
} else {
PreparedStatement pstmtval = conn.prepareStatement (
" Insert into countselect(id,listnum,selectype,totalcount) " +
" values( ?, ?, '2', 1)" ) ;
pstmtval.setInt(1,id);
pstmtval.setInt(2,listno);
pstmtval.executeUpdate();
conn.commit();
pstmtval.close();
}
*/
/* ----------------------------------------------------------------------------------------- */
conn.close();
}
catch (SQLException esql )
{
out.println (" Select Sql Error :" + esql.getMessage());
}
catch (Exception e )
{
out.println ("Exception: " + e.getMessage());
}
%>
|