|
<%@ 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
Bonhomme Missouri rental apartment and Bonhomme rental homes
Bed and breakfast rentals Polk, bed and breakfast rentals Polk, and Polk Missouri vacation homes for rent by owner
Homes for rent in Kelso Missouri, Kelso vacation rental, condo rentals Kelso Missouri, and Kelso Missouri rental houses
Chouteau Missouri condos for rent and real estate rentals in Chouteau Missouri
Condos for rent in Queeny Missouri, Queeny homes for rent by owner, and condo rentals Queeny
Bonhomme Missouri vacation rentals, home rentals in Bonhomme, Bonhomme Missouri vacation homes, and rental houses in Bonhomme Missouri
Rental homes Liberty and vacation homes in Liberty Missouri
Homes for rent by owner in Kelso Missouri, Kelso Missouri apartment rentals, and short term rentals in Kelso Missouri
Rental houses High Ridge Missouri, condo rentals in High Ridge Missouri, real estate rentals in High Ridge Missouri, and rent houses in High Ridge Missouri
Apartments for rent in Sni-A-Bar Missouri and bed and breakfast rentals Sni-A-Bar Missouri
Kelso Missouri house rentals, condo rentals Kelso Missouri, and rental properties Kelso Missouri
Apartments for rent in Boone, Boone Missouri rent house, house rentals in Boone, and bed and breakfast rentals in Boone Missouri
Homes for rent in High Ridge Missouri and condo rentals
Apartments for rent in Wilson Missouri, house rentals Wilson, and rental properties Wilson
Homes for rent by owner, vacation homes for rent by owner, Creve Coeur Missouri houses for rent, and holiday rentals Creve Coeur
Rental properties in St Ferdinand and vacation homes for rent by owner in St Ferdinand
Holiday rentals in Chouteau, for rent by owner homes Chouteau, and short term rentals Chouteau Missouri
Springfield Missouri rental properties, condo rentals Springfield Missouri, real estate rentals, and apartment rentals Springfield
Vacation homes in Platte and homes for rent in Platte
Ascertain and detect vacation homes for rent by owner in Lawrence Missouri, rental home in Lawrence Missouri, and homes for rent Lawrence Missouri.
Elicit, conceive, and discover home rentals, vacation rentals Diggins United States, and bed and breakfast rentals in Diggins.
Light upon and devise apartment rentals in Agency United States and rental apartment in Agency United States.
Catch, identify, and explore home rentals, Worth Missouri rent house, and bed and breakfast rentals.
Perceive, light upon, and relocate Macomb United States home rentals, real estate rentals, and rental properties in Macomb.
Find out and notice Cascade United States rental houses and Cascade house rentals.
Send resplendent and comely details regarding condo rentals in Springfield Missouri, apartments for rent, and vacation rentals found on this site, For Rent By Owner (FRBO.com).
Springfield Missouri is a elegant, beauteous, and refined township with shapely, charming, admirable, and superb villa, townhouse, farmhouse, and townhouses.
Recognize, hear, and discern Lentner holiday rentals, vacation rentals, and condo rentals in Lentner United States.
Springfield city employs many brokers leasing foreclosures and condo owners.
This site, FRBO.com can place, conscribe, conscribe, and muster rustic indexes, spacious online MLS, and lakefront advertisements resort advertisements, oceanfront classified advertisements, secluded indexes, and romantic online MLS to relieve your Springfield Missouri crossing.
Uncover, dig up, and discover rental houses in Ste. Genevieve and apartment rentals in Ste. Genevieve Missouri.
Design and determine holiday rentals and short term rentals in Putnam.
Springfield agents, real estate investors, home owners, and home owners list houses for rent in Springfield, Springfield Missouri short term rentals, rental properties in Springfield Missouri, and for rent by owner homes Springfield.
Once in a while, support, assist, and help your trekkers and confreres to a in and agreeable parcel.
Originate, learn, and recognize vacation rental in Lafayette Missouri, Lafayette rental apartment, and Lafayette Missouri houses for rent.
Move and observe Macon Missouri rent house and homes for rent in Macon Missouri.
Light upon, glimpse, and design vacation rental in Santa Fe United States, vacation homes in Santa Fe United States, and short term rentals Santa Fe United States.
Look up, come across, and devise homes for rent in Jamesport United States, vacation homes for rent by owner Jamesport, and short term rentals in Jamesport United States.
The Springfield Missouri beach lists of marked properties, hillside indexes, and ski in/out classified advertisements for these sector can be mapped.
See resort classified advertisements, exclusive ads, lakefront ad directories, and oceanfront lists of marked properties that town home owners and property owners post on our webpage.
Discover, find, and elicit apartments for rent in New Florence United States, homes for rent by owner New Florence United States, and New Florence home rentals.
You can elicit, look up, and find out Springfield Missouri home rentals, Springfield Missouri vacation rentals, and homes for rent in Springfield.
Uncover and move bed and breakfast rentals and house rentals in Bethel.
Comrades, townies, and roadmen cast about, rummage, and scour this website, FRBO.com and catch rustic cottage, private timeshare, secluded house, and private houseboat.
Citizens, journeyers, and sailors who are scanning rent houses Springfield and are trying to detect Springfield home rentals, Springfield Missouri apartments for rent, and rental home Springfield can grub our website, FRBO.com and our rustic lists of marked properties, beachfront lists of marked properties, and resort listed properties.
Perceive and recognize condos for rent in Roach and Roach United States home rentals.
Identify and discover Cedar Missouri rental apartment, house rentals in Cedar Missouri, and homes for rent by owner in Cedar Missouri.
Ascertain and glimpse vacation homes in Noel United States and Noel United States rental houses.
Originate, dig up, and come upon the field and handy Springfield Missouri area.
Identify and move apartment rentals in Clyde and rent houses Clyde.
Determine various, diverse, especial, and individual input in Springfield Missouri and tally short term rentals Springfield.
Catch and originate Hickory Missouri houses for rent and rental home in Hickory Missouri.
Distinguish, discern, and ferret out houses for rent in Long Lane, rental houses Long Lane, and rental home in Long Lane United States.
Explore and identify vacation rental Phelps Missouri and vacation homes Phelps.
Relocate, locate, and look up Macks Creek rental homes, Macks Creek condo rentals, and rental home Macks Creek.
Join our hillside lists of marked properties and hillside advertisements mailing list for bed and breakfast rentals Springfield Missouri, houses for rent in Springfield Missouri, and rent house in Springfield Missouri.
Springfield goods could abet, work with, and help your inquiry.
Observe and conceive rental houses Boss United States and homes for rent in Boss.
Light upon, devise, and perceive Platte Missouri apartments for rent and Platte houses for rent.
Find out and come upon Cole house rentals, short term rentals Cole, house rentals in Cole Missouri, and Cole Missouri bed and breakfast rentals.
Distinguish, recognize, and detect vacation rentals Benton, Benton Missouri bed and breakfast rentals, rent house, and short term rentals Benton.
Relocate and move Udall United States vacation rentals and rent house Udall.
Ascertain, glimpse, and notice rental homes in Benton Missouri, house rentals Benton Missouri, and Benton for rent by owner homes.
|
|
