|
<% if (count==0) { %> No matches were found.
<%} else { %>
Found <%=count %>,
<% if (pageNum
Displaying <%=pageNum*pageLimit+1 %>-<%=(pageNum+1)*pageLimit %>
<%} else { %>
Displaying <%=pageNum*pageLimit+1 %>-<%=pageNum*pageLimit+countReminder %>
<%} %>
<%
int the_count=0;
while (info_rs!=null && info_rs.next()) {
if (the_count>=page_min && the_countOpen house: ");
if (openhouse_str.trim().equalsIgnoreCase(""))
openhouse_str=null;
else
openhouse_str=openhouse_str.substring(0,openhouse_str.length()-23);
}
}
else {
String openhouse_mui=info_rs.getString(19);
String start_date=info_rs.getString(20);
if (start_date!=null) start_date=start_date.substring(0, 10);
else start_date="";
String start_time=info_rs.getString(21);
if (start_time==null) start_time="";
else {
if (start_time.length()>=7 && start_time.endsWith(":00")) {
start_time=start_time.substring(0, start_time.length()-3);
}
if (start_time.startsWith("0"))
start_time=start_time.substring(1);
}
String end_date=info_rs.getString(22);
if (end_date!=null) end_date=end_date.substring(0, 10);
else end_date="";
String end_time=info_rs.getString(23);
if (end_time==null) end_time="";
else {
if (end_time.length()>=7 && end_time.endsWith(":00")) {
end_time=end_time.substring(0, end_time.length()-3);
}
if (end_time.startsWith("0"))
end_time=end_time.substring(1);
}
String time_comments=info_rs.getString(24);
if (time_comments==null) time_comments="";
String is_active=info_rs.getString(25);
if (openhouse_mui!=null && !openhouse_mui.equalsIgnoreCase("NULL")){
openhouse_str=start_date+" "+start_time+" "+end_time;
openhouse_str=openhouse_str.trim();
openhouse_str=(openhouse_str+" "+time_comments).trim();
openhouse_str=u.parseOpenhouseStr(openhouse_str);
}
}
//System.out.println("2.openhouse_str="+openhouse_str);
String selling_price_str=info_rs.getString(28);
String County=info_rs.getString(34);
double Selling_Price=0.0;
if (selling_price_str!=null)
Selling_Price=Double.parseDouble(selling_price_str);
if (Selling_Price!=0.0) Listing_Price=Selling_Price;
%>
<%
if (isMarisPhoto==true){ %>
 |
<% } else {
File f_img=new File(RetsImageDir, Matrix_unique_id+"-0.jpeg");
if (f_img.exists()) { %>
 |
<% } else { %>
 |
<%}} String fullAddress=u.url_encoder(Full_Street_Name+", "+City+", "+State+" "+Zip_Code); %>
<%=the_count+1%>. <%=Full_Street_Name %>, <%=City %>, <%=State %> <%=Zip_Code %><%=Zip_Plus_4 %>
|
|
<% if (property_type_str.startsWith("Residential") || property_type_str.startsWith("Condo") || property_type_str.startsWith("New Construction")){ %>
| <%=property_type_str %> |
<%=Bedrooms_Str %> Bedrooms |
<%=Style %> |
County:<%=County %> |
|
<%=Bathrooms_Str %> Bathrooms |
<%=Square_Footage %> sqft |
|
<%} else { %>
| <%=property_type_str %> |
<%=Style %> |
<% if (Acres!=0.0) { %>
<%=Acres %> Acres Lot Size
<%} %> |
County:<%=County %> |
|
|
<% if (Square_Footage!=0.0) { %>
<%=Square_Footage %> sqft
<%} %> |
|
<%} %>
<% if (openhouse_str!=null){ %>
Open House: <%=openhouse_str %>
<%} %>
Brokered by <%=Office_Long_Name %> |
|
<% } the_count++;} %>
|
|
The information being provided by Mid America Regional Information System is for the consumer's personal,
non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be
interested in purchasing. Any information relating to real estate for sale referenced on this web site comes from the
Internet Data Exchange (IDX) program of the Mid America Regional Information System. BlueWorldRealty is not a Multiple
Listing Service (MLS), nor does it offer MLS access. This website is a service of BlueWorldReality, a broker participant
of Mid America Regional Information System. This web site may reference real estate listing(s) held by a brokerage firm
other than the broker and/or agent who owns this web site. Listings marked with an icon are provided courtesy of the Mid
America Regional Information System, Internet Data Exchange Database.
The accuracy of all information, regardless of source, including but not limited to open house information, square
footages and lot sizes, is deemed reliable but not guaranteed and should be personally verified through personal
inspection by and/or with the appropriate professionals. The data contained herein is copyrighted by Mid America
Regional Information System and is protected by all applicable copyright laws. Any unauthorized dissemination of this
information is in violation of copyright laws and is strictly prohibited.
Copyright 2015 Mid America Regional Information System. All rights reserved.
|
<%}}
if (qdata!=null)
qdata.closeDB(); %>
Blue World Realty, L.C. Information herein is for the St. Louis
metropolitan area.