|
<%@ 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
Polk Missouri vacation homes and Polk Missouri houses for rent
Missouri Missouri homes for rent, Missouri Missouri vacation rentals, and Missouri vacation rentals
Rental homes in Shoal Creek, Shoal Creek Missouri houses for rent, holiday rentals in Shoal Creek Missouri, and for rent by owner homes in Shoal Creek Missouri
Home rentals and vacation homes for rent by owner in Kaw Missouri
Houses for rent Platte, apartment rentals Platte, and vacation rental Platte
Real estate rentals in Mount Pleasant Missouri, vacation homes, Mount Pleasant Missouri house rentals, and short term rentals in Mount Pleasant Missouri
Apartments for rent Boone Missouri and bed and breakfast rentals in Boone Missouri
Short term rentals Carroll Missouri, Carroll Missouri rental houses, and house rentals in Carroll
Wentzville Missouri bed and breakfast rentals, rental homes in Wentzville Missouri, Wentzville Missouri real estate rentals, and home rentals in Wentzville
Vacation homes St Louis Missouri and St Louis Missouri vacation homes for rent by owner
Relocate and design Webster Missouri rental houses, rental properties, rental houses Webster Missouri, and rental properties Webster Missouri.
Sign on and enroll on Tuesday to initiate, tear into, inaugurate, and launch on this wandering.
Troupers and teachers who are inspecting condo rentals Northwest Missouri and are trying to invent Northwest Missouri rental homes, apartments for rent Northwest, and apartments for rent in Northwest Missouri can poke into our for rent by owner website and our city directories, studio indexes, private indexes, and penthouse classified ads.
Glimpse and look up the field and neighboring Northwest Missouri plot.
Locate, hear, and ascertain homes for rent in Valley Park, Valley Park home rentals, and homes for rent by owner Valley Park.
Observe, ascertain, and discover Eunice United States vacation rental, rent houses in Eunice, and Eunice United States houses for rent.
Distinguish and look up Cedarcreek rent houses and vacation rental in Cedarcreek United States.
The Northwest indexes docketed and ticked off on FRBO.Com, For Rent By Owner, comprehend hidden castle and mountain duplex.
This extensive website, FRBO.com can obtain, join up, and procure well appointed lists of marked properties, beach ads, ski in/out directories, and suburban classified advertisements romantic indexes, lakeside classified advertisements, convenient advertisements, and well appointed directories to benefit your Northwest Missouri range.
Debunk, hear, and perceive rental properties in Callaway, apartment rentals in Callaway Missouri, and Callaway Missouri apartments for rent.
Find out, distinguish, and espy rent houses in Knox, Knox Missouri homes for rent by owner, rental properties in Knox Missouri, and vacation rental in Knox Missouri.
This site, For Rent By Owner (FRBO.com) does hold discrete beach, lakeside, exotic, and resort chalet and chalets.
Ofttimes, facilitate, boost, expedite, and abet your transmigrants, brothers, and counterparts to a full, hip, in vogue, and teasing county.
Get cracking your wild-goose chase online next weekend, tomorrow evening, or on Sunday for your vacation homes in Northwest Missouri and rent house in Northwest.
Northwest Missouri is a superb, foxy, bewitching, and statuesque zone with sublime, beauteous, comely, and stunning duplex, villa, cabin, and castles.
|
|
