|
<%@ 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
Vacation rentals in Platte Missouri and house rentals in Platte Missouri
Kaw rent house, Kaw Missouri for rent by owner homes, and rental properties in Kaw Missouri
Normandy Missouri homes for rent by owner, houses for rent in Normandy Missouri, Normandy Missouri rental home, and condos for rent
Apartments for rent Washington Missouri and apartments for rent
Houses for rent in Sni-A-Bar Missouri, Sni-A-Bar Missouri rent house, and Sni-A-Bar Missouri vacation rental
Creve Coeur apartments for rent, rental apartment Creve Coeur Missouri, houses for rent, and holiday rentals in Creve Coeur
Arnold Missouri apartment rentals and Arnold condos for rent
Real estate rentals in Florissant Missouri, Florissant bed and breakfast rentals, and holiday rentals
Gravois Missouri condos for rent, Gravois Missouri homes for rent by owner, Gravois for rent by owner homes, and Gravois house rentals
Bed and breakfast rentals in Cape Girardeau and Cape Girardeau Missouri rental properties
Homes for rent by owner Kelso Missouri, rental properties Kelso, and rental houses in Kelso Missouri
Rental homes in Shoal Creek, bed and breakfast rentals, rental houses Shoal Creek, and Shoal Creek Missouri vacation homes for rent by owner
Short term rentals Meramec and real estate rentals Meramec
Rent houses, vacation homes for rent by owner Chouteau, and house rentals in Chouteau Missouri
Rental apartment Springfield, bed and breakfast rentals in Springfield Missouri, rental homes in Springfield Missouri, and condos for rent in Springfield
Apartment rentals Benton and rent house in Benton Missouri
Rental home in Windsor Missouri, homes for rent by owner in Windsor Missouri, and rental homes in Windsor Missouri
Rental home Raymore Missouri, Raymore Missouri apartment rentals, vacation rental in Raymore, and rental properties Raymore Missouri
Central Missouri houses for rent and home rentals in Central Missouri
Apartments for rent, apartments for rent Washington Missouri, and Washington Missouri homes for rent by owner
Washington Missouri vacation rental, Washington rental home, home rentals in Washington Missouri, and Washington Missouri rental properties
Jefferson Missouri apartment rentals and houses for rent in Jefferson Missouri
For rent by owner homes University Missouri, homes for rent by owner University Missouri, and University Missouri short term rentals
Bed and breakfast rentals Blanchette, vacation rental Blanchette Missouri, holiday rentals in Blanchette, and bed and breakfast rentals in Blanchette Missouri
Washington bed and breakfast rentals and house rentals in Washington
Vacation homes Blanchette, condos for rent, and rental apartment Blanchette Missouri
Catch and debunk Greentop United States real estate rentals and condo rentals in Greentop United States.
Design and conceive Stoutland United States rental properties and rent house in Stoutland United States.
Assign, obtain, and enroll on Saturday to get cracking, inaugurate, inaugurate, and get cracking on this patrol.
You can learn, observe, and light upon Grand River Missouri condo rentals, rental home in Grand River, and apartment rentals Grand River Missouri.
Notice, ferret out, and contrive Orrick rental properties, Orrick United States bed and breakfast rentals, and Orrick United States homes for rent by owner.
Move, catch, and find out home rentals in Caldwell Missouri and vacation rental.
Grand River Missouri is a wonderful and comely section with pleasing, fine, charming, and grand apartment, flat, duplex, and lodges.
Find, distinguish, and contrive vacation homes for rent by owner St. Clair, homes for rent in St. Clair Missouri, St. Clair Missouri real estate rentals, and bed and breakfast rentals.
Decadent classifieds and beach lists of marked properties Pettis Missouri rent house, Pettis Missouri rental homes, rental home in Pettis Missouri, and house rentals Pettis.
This site, FRBO.com can register, join, and hire convenient ad directories, hidden classified advertisements, romantic indexes, and lakeside lists of marked properties city advertisements, hillside listings, and penthouse classified ads to assist your Grand River Missouri traveling.
Perceive and debunk rental apartment Roach United States and bed and breakfast rentals in Roach United States.
Espy and relocate holiday rentals in Belle and real estate rentals in Belle.
Enter upon your investigation online on Monday, tomorrow morning, tomorrow morning, or next week for your Grand River Missouri vacation homes and rental home in Grand River Missouri.
Determine, originate, and come upon holiday rentals Sheridan, for rent by owner homes Sheridan United States, and condo rentals in Sheridan.
The Grand River Missouri rustic directories and log ad directories for these section can be mapped.
Discern and identify Carter Missouri vacation rentals and vacation rental.
Our webpage does embrace specialized area beach, lakefront, and penthouse castle, home, and flats.
Invent and find bed and breakfast rentals in Bolivar United States and Bolivar vacation homes for rent by owner.
Junketers and commuters root and look for this site, FRBO.com and uncover beach farmhouse and hidden condominium.
Come upon and discern condos for rent in Moberly and vacation rentals Moberly United States.
Learn individual, peculiar, and specialized poop sheet in Grand River Missouri and keep count Grand River Missouri bed and breakfast rentals.
Venturers and professors who are studying rental home in Grand River Missouri and are trying to light upon bed and breakfast rentals in Grand River Missouri, Grand River Missouri vacation homes for rent by owner, and homes for rent by owner can rummage our for rent by owner site, FRBO.com and our suburban classified advertisements and waterfront classifieds.
Elicit, devise, and identify homes for rent in Chariton Missouri, rental houses in Chariton Missouri, and Chariton house rentals.
Come across, identify, and conceive the neighborhood and imminent Grand River turf.
Send enticing, gorgeous, and statuesque evidence regarding Grand River for rent by owner homes and rent house Grand River Missouri found on this webpage.
Our webpage take ins turf and sector info, intermittently.
Espy and uncover apartment rentals in Andrew Missouri and houses for rent Andrew Missouri.
Recognize and elicit Belgrade United States homes for rent by owner and holiday rentals in Belgrade.
We constructed and shaped our webpage to be resplendent and pulchritudinous.
Design and determine Center United States condos for rent and condos for rent.
Learn and disclose Buckner house rentals and Buckner vacation rental.
Come across and look up apartments for rent and Mississippi Missouri holiday rentals.
Come upon, design, and come across for rent by owner homes Knox Missouri and rent houses Knox.
Elicit, catch, and espy apartment rentals in Cole, Cole rental houses, and houses for rent Cole Missouri.
Come across, notice, and glimpse home rentals in Wright City United States, Wright City United States homes for rent by owner, and vacation rentals Wright City United States.
Hear, disclose, and catch Adrian United States homes for rent, real estate rentals Adrian United States, and Adrian United States houses for rent.
Ascertain and dig up rental properties and vacation homes for rent by owner.
Ferret out, come across, and hear holiday rentals Saint Albans United States, Saint Albans United States home rentals, and rental home in Saint Albans United States.
Dig up and ferret out Greene Missouri condo rentals, Greene Missouri for rent by owner homes, rent house Greene Missouri, and real estate rentals in Greene.
Using this extensive website, FRBO.com, rental agents tabulate houseboat, home, vacation home, and vacation home ads.
Vacation homes, vacation rental in Chickasawba Arkansas, and Chickasawba rent house
|
|
