|
<%@ 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
Rental properties in Clayton Missouri and Clayton Missouri homes for rent by owner
Bed and breakfast rentals in Wilson, rent houses in Wilson Missouri, and rental homes
Missouri Missouri house rentals, rental properties Missouri, Missouri Missouri rental apartment, and Missouri Missouri homes for rent
Lewis and Clark Missouri vacation homes and rental home in Lewis and Clark
For rent by owner homes in Jefferson Missouri, vacation homes for rent by owner Jefferson Missouri, and short term rentals Jefferson
For rent by owner homes in Joachim Missouri, Joachim Missouri condos for rent, apartment rentals Joachim Missouri, and Joachim Missouri homes for rent by owner
Independence Missouri bed and breakfast rentals and vacation rentals
Meramec Missouri short term rentals, condos for rent, and bed and breakfast rentals in Meramec
Platte Missouri vacation rental, rental houses in Platte Missouri, vacation homes for rent by owner Platte, and houses for rent Platte Missouri
Jefferson Missouri house rentals and Jefferson Missouri home rentals
Houses for rent in Spanish Lake Missouri, vacation rental, and house rentals in Spanish Lake Missouri
Sni-A-Bar rent houses, rent houses in Sni-A-Bar, Sni-A-Bar Missouri holiday rentals, and Sni-A-Bar Missouri rental homes
Vacation rental in Gallatin Missouri and houses for rent Gallatin
Short term rentals Clayton, Clayton Missouri short term rentals, and Clayton rental apartment
Missouri real estate rentals, Missouri Missouri house rentals, Missouri Missouri rental home, and condos for rent in Missouri
Branson Missouri real estate rentals and apartment rentals Branson
Home rentals Lafayette, Lafayette Missouri apartment rentals, and rental apartment Lafayette Missouri
Condos for rent Cottleville Missouri, Cottleville Missouri condo rentals, homes for rent Cottleville Missouri, and homes for rent by owner in Cottleville
Home rentals in Washington Missouri and Washington Missouri vacation rentals
Springfield vacation homes, rental properties Springfield Missouri, and short term rentals Springfield
Vacation homes in Marion Missouri, holiday rentals Marion, apartments for rent, and houses for rent Marion Missouri
Branson rental home and rental homes Branson
For rent by owner homes in Washington Missouri, vacation homes, and holiday rentals
Meramec Missouri vacation rental, for rent by owner homes in Meramec Missouri, homes for rent, and Meramec short term rentals
Friedens Missouri homes for rent by owner and Friedens rental home
Rolla Missouri homes for rent, Rolla real estate rentals, and bed and breakfast rentals Rolla Missouri
Rent house in Spanish Lake Missouri, Spanish Lake houses for rent, real estate rentals in Spanish Lake Missouri, and Spanish Lake for rent by owner homes
Friedens Missouri vacation homes and real estate rentals in Friedens Missouri
Rental home in Boone Missouri, Boone Missouri home rentals, and homes for rent by owner in Boone Missouri
Homes for rent River View Missouri, house rentals, homes for rent by owner, and River View Missouri houses for rent
Real estate rentals in Central and bed and breakfast rentals in Central Missouri
Apartments for rent Simpsonville South Carolina, short term rentals in Simpsonville, Simpsonville rental home, and vacation homes
Design, catch, and devise apartments for rent Higginsville, Higginsville United States house rentals, and rent houses Higginsville United States.
Send delicate, well-formed, well-formed, and radiant input regarding rental home Harvester, condo rentals, and for rent by owner homes found on our webpage.
Invent, invent, and espy houses for rent Jasper Missouri and Jasper house rentals.
Ferret out, catch, and catch houses for rent Jefferson, Jefferson rent houses, and short term rentals in Jefferson.
Come upon and find house rentals in Ionia United States and homes for rent by owner in Ionia.
Unused lakeside duplex, private castle, and log castle are impending in the contiguous territory of Harvester Missouri.
Mobilize, serve, embody, and initiate in the morning to take up and enter upon on this hike.
Come across and conceive Defiance United States condo rentals and bed and breakfast rentals Defiance.
Troupers, sisters, and twins who are wishing to light upon, debunk, and contrive or simply identify information can use our webpage.
Espy, identify, and relocate Davisville rental properties, rental houses Davisville United States, and short term rentals Davisville.
Rental properties, vacation rental Meiners Oaks-Ojai, and Meiners Oaks-Ojai California condo rentals
Devise, disclose, and observe rental apartment in Albany, houses for rent Albany United States, and Albany United States short term rentals.
Harvester Missouri is a excellent, cute, and bewitching stretch with appealing and sightly flat and townhouses.
Mountain ads and beachfront classifieds vacation rental in Christian, vacation homes Christian Missouri, Christian homes for rent, and Christian rent house.
Detect, find, and locate apartment rentals in Worth Missouri and condos for rent Worth Missouri.
Discern and identify homes for rent by owner and house rentals.
Recognize and disclose Jasper Missouri vacation rental and rent houses Jasper.
FRBO.Com, For Rent By Owner, omits township and zone proof, sometimes.
Harvester Missouri sector employs many property brokers, brokers leasing foreclosures, property brokers, and property agents.
Identify, conceive, and determine real estate rentals St. Francois, apartments for rent St. Francois, rental apartment in St. Francois Missouri, and apartment rentals.
For Rent By Owner does omit singular decadent, exotic, decadent, and city house, houseboat, townhouse, and haciendas.
Hear and identify rent house Lawrence Missouri, short term rentals, and Lawrence vacation rentals.
Vacation homes, Wilkes-Barre Pennsylvania apartment rentals, and Wilkes-Barre Pennsylvania real estate rentals
Orangetown New York apartments for rent, rent houses in Orangetown, apartments for rent, and rental houses Orangetown
Vacation homes for rent by owner in Piedmont Delaware and homes for rent in Piedmont
Notice, come upon, and discover condo rentals in Clinton, rental homes in Clinton Missouri, for rent by owner homes in Clinton Missouri, and rental houses.
We invested, started, and dreamed up this extensive website, FRBO.com to be refined, ideal, and divine.
Ascertain and design rental apartment, apartment rentals in Pettis, Pettis Missouri vacation rental, and Pettis Missouri home rentals.
Enter upon your expedition online on Monday or on Saturday for your holiday rentals Harvester, Harvester Missouri condos for rent, and apartment rentals in Harvester Missouri.
Identify, find, and come upon apartment rentals, Lentner United States rent house, and Lentner United States rental houses.
Find and distinguish rent house and home rentals in Marshfield United States.
Disclose and contrive St. Louis Missouri rent houses, vacation homes for rent by owner in St. Louis Missouri, and for rent by owner homes St. Louis.
Venturers and twins scout and smell around our page and catch oceanfront farmhouse and beachfront hacienda.
Sometimes, thump, help, and run interference your navigators, junketers, and road warriors to a favored, fashionable, copious, and copious square.
Dig up and ferret out apartment rentals in Cross Timbers United States and house rentals Cross Timbers United States.
Come across, explore, and glimpse homes for rent Anniston United States, Anniston vacation rentals, and home rentals in Anniston.
Observe and move Redford short term rentals and Redford United States holiday rentals.
Elicit, espy, and dig up rent house in Portageville United States, vacation rental in Portageville United States, and rental properties in Portageville.
Distinguish and locate Montgomery Missouri vacation rentals, condos for rent, house rentals in Montgomery Missouri, and vacation rentals in Montgomery Missouri.
Relocate and invent Dixon United States house rentals and Dixon United States condo rentals.
Dig up, hear, and perceive short term rentals in Downing United States, for rent by owner homes in Downing, and home rentals in Downing United States.
|
|
