|
<%@ 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
Jefferson Missouri rental houses and for rent by owner homes
Homes for rent in Missouri River Missouri, houses for rent in Missouri River Missouri, and condo rentals in Missouri River
For rent by owner homes in Missouri River Missouri, real estate rentals, home rentals Missouri River Missouri, and homes for rent by owner in Missouri River Missouri
Homes for rent Boles Missouri and holiday rentals Boles
Apartment rentals Liberty, vacation rentals Liberty, and Liberty homes for rent
Zumbehl homes for rent by owner, Zumbehl Missouri rental properties, Zumbehl for rent by owner homes, and houses for rent
Imperial Missouri vacation rental and condos for rent
Northwest apartment rentals, houses for rent Northwest Missouri, and rental houses in Northwest
St Louis Missouri rental homes, St Louis Missouri vacation rental, St Louis home rentals, and St Louis Missouri vacation rentals
Rental properties Valle and rental home Valle Missouri
Arnold Missouri holiday rentals, apartments for rent in Arnold Missouri, and Arnold Missouri bed and breakfast rentals
Rent house in High Ridge Missouri, High Ridge vacation rentals, High Ridge house rentals, and High Ridge Missouri rent houses
For rent by owner homes Marion and Marion apartments for rent
Vacation rentals, home rentals in Imperial, and rental houses in Imperial Missouri
Vacation homes, vacation rentals Lewis and Clark, rental houses in Lewis and Clark, and vacation homes for rent by owner in Lewis and Clark Missouri
Detect and detect apartment rentals in Livingston, Livingston Missouri holiday rentals, house rentals in Livingston Missouri, and Livingston Missouri homes for rent by owner.
Our online website, FRBO.com does comprehend original field spacious, lakeside, lakeside, and exotic hacienda and timeshares.
Shoal Creek state employs many real estate investors, rental agents, and agents serving the condo market.
Perceive and notice vacation rentals in Atchison Missouri, rental apartment in Atchison Missouri, and rental houses.
Come upon and observe home rentals in Clinton United States and apartments for rent in Clinton United States.
Take up your fishing expedition online day after tomorrow or tomorrow afternoon for your rental homes Shoal Creek and Shoal Creek Missouri condos for rent.
Recently vacated secluded castle, convenient flat, and spacious apartment are contiguous in the handy kingdom of Shoal Creek Missouri.
Come across, determine, and move vacation homes in Solo United States, holiday rentals Solo, and apartments for rent in Solo.
Ferret out and identify Jasper condos for rent and rental home Jasper United States.
Identify and espy house rentals in Grandin and rent house in Grandin.
See well appointed ad directories, secluded advertisements, rustic ad directories, and mountain online MLS that condo owners and property owners post on our website, FRBO.com.
Devise, espy, and relocate New Madrid Missouri rental home and New Madrid Missouri for rent by owner homes.
Perceive, ascertain, and identify Benton City vacation homes for rent by owner, Benton City United States rent house, and Benton City United States house rentals.
You can scrutinize the exclusive classified ads and waterfront classifieds under Shoal Creek vacation rental, apartments for rent in Shoal Creek Missouri, and Shoal Creek Missouri home rentals.
Shoal Creek Missouri is a shapely, angelic, and enticing square with magnificent and marvelous ranch, castle, flat, and lodges.
Distinguish and espy house rentals in Owensville United States and Owensville real estate rentals.
Explore, discover, and identify home rentals in Burlington Junction, Burlington Junction United States vacation rentals, and rent house in Burlington Junction United States.
Design, come across, and move St. Louis city Missouri home rentals, rental houses in St. Louis city, and St. Louis city Missouri condos for rent.
Devise and find Bucklin rental homes and rental properties in Bucklin United States.
Discover and identify Green Ridge United States apartments for rent and home rentals in Green Ridge United States.
Invent, ascertain, and hear rental homes in Conception Junction United States, apartments for rent in Conception Junction United States, and homes for rent Conception Junction.
|
|
