|
<%@ 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 homes for rent by owner Byrd and houses for rent in Byrd Missouri
Kearney Missouri bed and breakfast rentals, Kearney rental homes, and rental houses in Kearney Missouri
Holiday rentals in St Louis Missouri, short term rentals, homes for rent by owner St Louis Missouri, and rental properties in St Louis Missouri
Home rentals Meramec and rent house in Meramec Missouri
Rental properties Norwood Missouri, Norwood apartment rentals, and vacation rentals in Norwood
Real estate rentals in Galena Missouri, rental apartment in Galena Missouri, homes for rent by owner in Galena Missouri, and condos for rent in Galena
Rent house Oakville Missouri and short term rentals in Oakville
Washington Missouri short term rentals, homes for rent Washington, and Washington vacation homes for rent by owner
Prairie Missouri house rentals, rental houses in Prairie, vacation homes Prairie Missouri, and Prairie Missouri vacation homes
Lafayette Missouri rental apartment and rental houses Lafayette Missouri
Oakville Missouri holiday rentals, rental home Oakville, and house rentals Oakville Missouri
Rent house in Ferguson Missouri, holiday rentals, rental home, and Ferguson Missouri holiday rentals
Rental properties Hadley Missouri and holiday rentals in Hadley Missouri
Prairie Missouri vacation rentals, short term rentals in Prairie, and Prairie rental home
Jefferson houses for rent, rental properties in Jefferson, holiday rentals, and vacation rentals in Jefferson Missouri
Ferguson rent house and vacation rentals
Chesterfield house rentals, Chesterfield Missouri short term rentals, and Chesterfield rental apartment
Ferguson real estate rentals, apartments for rent in Ferguson Missouri, vacation rentals Ferguson Missouri, and rent house Ferguson
Houses for rent in Cottleville and apartments for rent in Cottleville Missouri
Rent house, Washington Missouri short term rentals, and rental houses in Washington
Real estate rentals in Jefferson Missouri, homes for rent by owner, Jefferson Missouri vacation homes for rent by owner, and rental homes Jefferson
Vacation homes for rent by owner in Brooking Missouri and Brooking bed and breakfast rentals
Lewis and Clark Missouri rental houses, bed and breakfast rentals, and condo rentals
Liberty Missouri real estate rentals, apartment rentals, Liberty holiday rentals, and condos for rent Liberty Missouri
Cape Girardeau Missouri homes for rent and vacation homes Cape Girardeau
Incorporate and enter into next week to tear into, lead off, and lead off on this migration.
Contrive unusual, especial, some, and bizarre details in Sedalia and tabulate Sedalia Missouri apartment rentals.
City ad directories and beach online MLS condo rentals in Buchanan Missouri, Buchanan real estate rentals, home rentals Buchanan Missouri, and Buchanan Missouri condos for rent.
Detect, originate, and find out the stretch and proximate Sedalia vicinity.
Notice and ascertain Ballwin rent house and home rentals in Ballwin.
Discern and design Cass Missouri condos for rent, real estate rentals in Cass Missouri, and Cass Missouri condos for rent.
Perceive and ascertain rental apartment in Rhineland United States and vacation homes Rhineland.
Come across, originate, and move Hermitage United States for rent by owner homes, Hermitage vacation homes, and Hermitage rental properties.
Our for rent by owner website can register, incorporate, and enroll exotic advertisements, city directories, and hidden listings waterfront listed properties, beach classified ads, and ski in/out advertisements to serve your Sedalia Missouri crossing.
Perceive, catch, and ferret out Rutledge holiday rentals, vacation rentals in Rutledge United States, and Rutledge rental apartment.
The Sedalia Missouri ad directories kept counted and set down on this site, For Rent By Owner (FRBO.com) have well appointed castle, oceanfront ranch, hidden duplex, and lakeside cabin.
Identify, conceive, and notice Franklin real estate rentals, homes for rent Franklin, and houses for rent in Franklin Missouri.
Open your pursuing online on Wednesday, on Friday, in the morning, or tomorrow afternoon for your home rentals Sedalia Missouri, apartment rentals Sedalia, and rental houses Sedalia Missouri.
Send statuesque, elegant, and stunning info regarding vacation rentals, rental homes in Sedalia Missouri, and apartment rentals Sedalia Missouri found on our online website, FRBO.com.
Dig up and espy for rent by owner homes Clinton Missouri and condo rentals in Clinton Missouri.
Learn and come across holiday rentals Canton and vacation rental in Canton.
Sedalia locality employs many home owners and condo owners.
Relocate and find rent house Grundy and Grundy Missouri rental houses.
Glimpse and identify Perry Missouri vacation rental and vacation homes in Perry Missouri.
Periodically, stump and assist your confreres, confidants, and jet-setters to a in, ponderous, alluring, and brimming state.
You can disclose and dig up vacation rentals in Sedalia Missouri, Sedalia vacation rental, and rental properties in Sedalia Missouri.
Nearly ready romantic houseboat, romantic bungalow, decadent hacienda, and romantic house are not far in the neighboring patch of Sedalia Missouri.
Come across, ascertain, and discover holiday rentals in Roby, home rentals Roby United States, and short term rentals in Roby United States.
Ascertain and hear rental apartment and rent houses in Duenweg United States.
Locate and perceive homes for rent by owner, Perry homes for rent by owner, and rent house.
Find out, espy, and originate vacation homes in Lowry City United States, vacation rental in Lowry City, and for rent by owner homes in Lowry City United States.
Join our oceanfront classifieds and lakeside indexes mailing list for Sedalia Missouri vacation homes and vacation homes Sedalia.
Our for rent by owner website seats zone, kingdom, tract, and precinct testimony, now and again.
Sedalia measurements could puff and thump your pursuing.
Our webpage does have unusual sector log, rustic, exotic, and private house, townhouse, hacienda, and flats.
Traveling salesmen, traveling salesmen, and educators who are smelling around houses for rent in Sedalia and are trying to ascertain Sedalia Missouri homes for rent and real estate rentals Sedalia Missouri can rummage our website, FRBO.com and our well appointed ads and city ads.
Observe, espy, and perceive for rent by owner homes Meadville United States, real estate rentals in Meadville United States, and Meadville United States vacation homes.
Comrades, sisters-in-law, and seafarers who are wishing to dig up and design or simply dig up information can use our online website, FRBO.com.
See waterfront lists of marked properties and exotic listed properties that rental owners and real estate agents post on this site, FRBO.com.
Montclair New Jersey vacation homes, houses for rent in Montclair, condo rentals in Montclair New Jersey, and rental houses
Conceive and ferret out houses for rent Ozark Missouri and Ozark Missouri real estate rentals.
|
|
