|
<%@ include file="../WEB-INF/jsp/city_side_menu2.jspf" %>
|
|
<%@ include file="../WEB-INF/jsp/top_menu.jspf" %>
|
<%=city_name%>, <%=region_name%>
Filter the results on the map and on the property list by changing criteria.
All properties meeting criteria are shown automatically.
|
|
Properties in <%=city_name%>
| Property ID |
Address |
City |
Bedrooms |
Bathrooms |
Square feet |
<%@ include file="/WEB-INF/jsp/radius_function.jsp" %>
<%
Connection con = null;
try {
// lat and lng definition are on file city_scriptlet.jspf
double[] cords = getRadiusCords(60, lat, lng);
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/sstrehli1?user=sstrehli1&password=frboadmin2007");
String query = "SELECT property_id, address, country_id, country_name, bedrooms, bathrooms, sqft, property.latitude, property.longitude, cities.city, property.city_id FROM property, cities WHERE property.city_id = cities.city_id AND property.enabled = 1 AND property.latitude >= " + cords[0] + " AND property.longitude >= " + cords[1] + " AND property.latitude <= " +cords[2] + " AND property.longitude <= " +cords[3];
PreparedStatement Ps = con.prepareStatement(query);
//Ps.setInt(1,city_id);
ResultSet Rs = Ps.executeQuery();
while(Rs.next()) {
long property_id = Rs.getLong("property_id");
int country_id = Rs.getInt("country_id");
double latitude = Rs.getDouble("latitude");
double longitude = Rs.getDouble("longitude");
String address = Rs.getString("address");
String country_name = Rs.getString("country_name");
String city_name2 = Rs.getString("city");
int city_id2 = Rs.getInt("city_id");
int bedrooms = Rs.getInt("bedrooms");
int bathrooms = Rs.getInt("bathrooms");
int sqft = Rs.getInt("sqft");
String query2 = "SELECT date_in, date_out FROM rates WHERE property_id = ?";
PreparedStatement Ps2 = con.prepareStatement(query2);
Ps2.setLong(1, property_id);
ResultSet Rs2 = Ps2.executeQuery();
%>
| #<%=property_id%> |
<%=address%> |
<%=city_name2%> |
<%=bedrooms%> |
<%=bathrooms%> |
<%=sqft%> |
<%
Rs2.close();
Ps2.close();
}
Rs.close();
Ps.close();
con.close();
con = null;
} catch(Exception e) {out.print(e.toString()); out.print(e.getMessage());
}
finally {
if(con!=null) {
con.close();
con = null;
}
}
%>
| |
|
|
|
|
|
<%@ include file="../WEB-INF/jsp/footer.jspf" %>
|
Missouri Rental Links
House rentals Oakville and houses for rent in Oakville Missouri
Short term rentals, May Missouri vacation homes, and apartments for rent May Missouri
Shoal Creek Missouri apartments for rent, rental apartment, Shoal Creek Missouri homes for rent by owner, and bed and breakfast rentals in Shoal Creek Missouri
Condos for rent in Midland Missouri and rental apartment Midland Missouri
Bed and breakfast rentals in Blanchette, Blanchette Missouri vacation homes for rent by owner, and for rent by owner homes in Blanchette Missouri
Cullen Missouri rent houses, rent house in Cullen Missouri, Cullen Missouri rental home, and Cullen Missouri rental home
Condo rentals and Independence Missouri vacation rental
Rental home Ferguson, house rentals, and Ferguson Missouri apartment rentals
Rental houses in Meramec Missouri, rent house in Meramec Missouri, rental home in Meramec Missouri, and home rentals
Lemay Missouri rental apartment and Lemay Missouri rental apartment
Move and detect house rentals in Mississippi, vacation homes for rent by owner in Mississippi, short term rentals in Mississippi Missouri, and Mississippi rental houses.
Meramec principality employs many condo owners, third party listing companies, and third party listing companies.
FRBO.Com, For Rent By Owner, does comprise extraordinary decadent, oceanfront, and waterfront chalet, townhouse, hacienda, and cabins.
Conceive and locate apartment rentals and homes for rent in Creighton United States.
Disclose and determine Alma United States rental houses and vacation homes for rent by owner Alma.
Relocate, identify, and distinguish for rent by owner homes in Wheatland United States, houses for rent in Wheatland United States, and Wheatland United States vacation homes.
See loft ad directories, romantic ads, beachfront ad directories, and well appointed advertisements that third party listing companies and property agents post on this site, FRBO.com.
This webpage comprehends area and kingdom dossier, ordinarily.
Disclose and determine Essex bed and breakfast rentals and Essex United States real estate rentals.
Take up your inspection online this week, this weekend, on Tuesday, or tonight for your holiday rentals Meramec, rental homes, and apartment rentals.
Join our hidden lists of marked properties and exotic ad directories mailing list for Meramec Missouri apartment rentals, vacation rental Meramec, and rental houses in Meramec Missouri.
Send gorgeous and shapely scoop regarding Meramec Missouri home rentals, rent houses in Meramec Missouri, Meramec Missouri condos for rent, and real estate rentals in Meramec Missouri found on our website, FRBO.com.
Hear original, especial, strange, and particular details in Meramec Missouri and numerate Meramec Missouri rental homes.
Come upon, identify, and disclose Rock Port United States homes for rent by owner, Rock Port houses for rent, and homes for rent in Rock Port United States.
You can relocate, debunk, and find house rentals Meramec Missouri and Meramec Missouri rent houses.
Identify and elicit holiday rentals and Iron Missouri rent house.
You can check the resort lists of marked properties, log online MLS, secluded classified ads, and beach advertisements under house rentals in Meramec Missouri and holiday rentals Meramec.
Using our webpage, property brokers catalogue hacienda and vacation home classifieds.
The Meramec Missouri classified advertisements inscribed and manifested on our online website, FRBO.com comprise spacious townhouse, log condominium, and city hacienda.
|
|
