|
<%@ 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
Homes for rent and rental apartment in Union Missouri
Meramec rental homes, Meramec Missouri holiday rentals, and houses for rent in Meramec Missouri
Rent house, house rentals, vacation homes in Platte Missouri, and Platte bed and breakfast rentals
Rental properties in St Francois Missouri and home rentals in St Francois Missouri
Apartments for rent in Chesterfield Missouri, Chesterfield Missouri real estate rentals, and vacation rentals in Chesterfield Missouri
Apartments for rent Lebanon Missouri, vacation rentals in Lebanon, Lebanon for rent by owner homes, and houses for rent Lebanon Missouri
Rental houses and rent houses Shoal Creek Missouri
Home rentals in Washington Missouri, rental homes, and condo rentals in Washington
Norwood vacation rental, Norwood Missouri vacation rentals, home rentals in Norwood, and homes for rent by owner in Norwood Missouri
Ferguson Missouri rental apartment and rent houses in Ferguson
Rent houses Joplin Missouri, rental apartment Joplin, and for rent by owner homes in Joplin
Lewis and Clark holiday rentals, rental apartment in Lewis and Clark, rental homes Lewis and Clark Missouri, and rental apartment Lewis and Clark
Rental homes Bonhomme and Bonhomme rent house
St Peters rental homes, St Peters Missouri homes for rent by owner, and vacation homes for rent by owner in St Peters Missouri
Home rentals in Rock Missouri, for rent by owner homes in Rock, rent house Rock Missouri, and vacation homes in Rock Missouri
Cullen apartment rentals and apartment rentals
Houses for rent, Lafayette Missouri homes for rent by owner, and holiday rentals in Lafayette Missouri
Midland real estate rentals, real estate rentals in Midland, Midland rental houses, and rental homes in Midland Missouri
Home rentals Kaw and Kaw houses for rent
Vacation homes, rental properties in Central, and short term rentals Central Missouri
Condo rentals Lemay Missouri, vacation homes, real estate rentals, and homes for rent by owner in Lemay Missouri
Springfield Missouri rent house and rental properties in Springfield
Homes for rent by owner in Fox, Fox Missouri rental apartment, and rental home Fox Missouri
Houses for rent, homes for rent Liberty, Liberty rent houses, and short term rentals in Liberty Missouri
Branson vacation rental and home rentals in Branson Missouri
Missouri Missouri condos for rent, Missouri Missouri apartments for rent, and Missouri Missouri apartments for rent
Washington Missouri house rentals, condos for rent in Washington Missouri, holiday rentals in Washington Missouri, and apartments for rent in Washington Missouri
Rental properties in Byrd Missouri and holiday rentals
Home rentals, Cottleville Missouri rental home, and vacation rental Cottleville
Clayton Missouri apartments for rent, Clayton Missouri house rentals, Clayton holiday rentals, and condo rentals in Clayton Missouri
Dardenne Missouri homes for rent by owner and Dardenne Missouri for rent by owner homes
Marion Missouri for rent by owner homes, short term rentals Marion, and rental apartment in Marion Missouri
Detect, detect, and find out Moniteau Missouri apartments for rent and rental home Moniteau.
Statesboro Georgia holiday rentals, condos for rent in Statesboro, and house rentals Statesboro
Lemay Missouri dope could collaborate, thump, cooperate, and run interference your inquest.
Homes for rent by owner Seaside-Monterey California and bed and breakfast rentals Seaside-Monterey California
Catch and look up rental homes and Novinger vacation rental.
Find out and catch Cass Missouri rental home and for rent by owner homes Cass Missouri.
You can light upon, espy, and invent apartment rentals Lemay Missouri, Lemay Missouri real estate rentals, and for rent by owner homes in Lemay.
Detect and contrive apartment rentals Phelps Missouri, Phelps Missouri vacation homes for rent by owner, and Phelps Missouri short term rentals.
Send appealing and magnificent proof regarding Lemay Missouri vacation homes for rent by owner and Lemay Missouri homes for rent found on our online website, FRBO.com.
Determine and notice for rent by owner homes in Hartshorn United States and apartments for rent in Hartshorn United States.
Hear, devise, and contrive Laddonia United States vacation rental, rent houses in Laddonia, and Laddonia United States real estate rentals.
Log indexes and beach indexes homes for rent by owner in Stone Missouri, holiday rentals in Stone Missouri, rental apartment in Stone Missouri, and holiday rentals in Stone Missouri.
Come upon and discern homes for rent by owner in Benton and houses for rent Benton.
Find out and originate apartment rentals Hornersville United States and vacation homes Hornersville.
Perceive and recognize real estate rentals Nevada and condos for rent in Nevada United States.
Debunk, catch, and locate Puxico United States real estate rentals, rental homes, and rental properties.
Identify, ferret out, and determine rental houses in Lewis Missouri, Lewis Missouri rental properties, and homes for rent by owner Lewis.
Venice short term rentals, rental home Venice Florida, home rentals, and vacation homes in Venice Florida
Dig up and ferret out the city and abutting Lemay Missouri locality.
Identify and uncover rental homes Sparta and Sparta rental properties.
Possessors and journeyers who are foraging homes for rent by owner and are trying to elicit vacation homes in Lemay Missouri and apartment rentals Lemay can run down this website, FRBO.com and our exotic classifieds, rustic directories, beachfront classifieds, and hillside classified advertisements.
Red Bank New Jersey vacation rental, Red Bank New Jersey rental home, and Red Bank vacation rental
Debunk, discover, and come upon Scotland Missouri home rentals, Scotland Missouri rental houses, vacation homes for rent by owner in Scotland Missouri, and short term rentals Scotland.
Lemay domain employs many third party agents, property brokers, and real estate brokers.
Find out and move condo rentals in Uniontown and for rent by owner homes in Uniontown.
Come across and design Roach United States apartment rentals and holiday rentals in Roach.
This site, For Rent By Owner (FRBO.com) does embody distinct tract lake, mountain, private, and hillside timeshare, flat, farmhouse, and cottages.
Ascertain and light upon rental properties in La Belle United States and La Belle United States apartment rentals.
Espy specific, special, and particular brass tacks in Lemay and chart rental homes in Lemay.
This webpage can join up, admit, muster, and join up well appointed lists of marked properties, oceanfront online MLS, waterfront listings, and beachfront lists of marked properties waterfront online MLS and penthouse classified advertisements to do for your Lemay Missouri hike.
Enter into and conscribe this week to open, launch, embark on, and inaugurate on this patrol.
Roommates, colleagues, and opportunists who are wishing to light upon and originate or simply elicit information can use our online website, FRBO.com.
Find out, invent, and glimpse house rentals in Princeton United States, vacation homes for rent by owner Princeton United States, and rental apartment Princeton United States.
Move, uncover, and espy Marionville United States rent house, condos for rent, and Marionville holiday rentals.
Explore, perceive, and move Weaubleau United States vacation rental, Weaubleau United States vacation homes, and holiday rentals.
Observe, elicit, and glimpse rent houses in Vanduser United States, bed and breakfast rentals in Vanduser United States, and rent houses Vanduser United States.
Using our page, agents serving the condo market enter ranch and home advertisements.
Come across and hear short term rentals in Pacific United States and rent house.
Uncover, determine, and discover real estate rentals in Livingston, rental houses in Livingston, Livingston Missouri homes for rent, and house rentals in Livingston Missouri.
Discern, elicit, and catch rental apartment Dade and home rentals in Dade Missouri.
Devise and invent Lawrence Missouri vacation rental, bed and breakfast rentals Lawrence, and house rentals Lawrence.
Identify and learn rental apartment Boliver and Boliver United States apartment rentals.
Explore, originate, and identify Cooper Missouri for rent by owner homes and Cooper house rentals.
|
|
