|
<%@ 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
Holiday rentals in Gravois Missouri and rental homes in Gravois Missouri
Holiday rentals Fishing River Missouri, vacation rentals, and Fishing River for rent by owner homes
Vacation homes University Missouri, University Missouri rental properties, University Missouri rental properties, and rental properties
Independence Missouri rental homes and Independence Missouri apartments for rent
Rental home in Cedar Missouri, Cedar bed and breakfast rentals, and rental home Cedar Missouri
Wentzville Missouri bed and breakfast rentals, Wentzville Missouri short term rentals, apartments for rent in Wentzville Missouri, and Wentzville Missouri condos for rent
Rental home in Kelso Missouri and homes for rent by owner Kelso Missouri
Homes for rent by owner in Cedar Missouri, rental apartment Cedar, and bed and breakfast rentals Cedar Missouri
Rental home in Marion Missouri, Marion Missouri apartments for rent, Marion bed and breakfast rentals, and Marion short term rentals
Vacation rental in Norwood and bed and breakfast rentals
Chesterfield Missouri short term rentals, vacation homes for rent by owner in Chesterfield Missouri, and vacation rental in Chesterfield Missouri
Condo rentals in Frontier Missouri, house rentals Frontier Missouri, home rentals Frontier Missouri, and Frontier rental apartment
House rentals in Sedalia and Sedalia Missouri vacation rental
Homes for rent Cape Girardeau Missouri, rent house in Cape Girardeau Missouri, and condos for rent in Cape Girardeau
High Ridge Missouri rental apartment, High Ridge Missouri short term rentals, High Ridge Missouri vacation rentals, and bed and breakfast rentals High Ridge Missouri
Rolla Missouri rental apartment and Rolla rental properties
Real estate rentals in Boone Missouri, homes for rent by owner in Boone Missouri, and Boone Missouri vacation homes for rent by owner
Bed and breakfast rentals in Ferguson, condo rentals, home rentals in Ferguson, and real estate rentals in Ferguson Missouri
Kelso vacation rental and Kelso Missouri rental apartment
Real estate rentals in Halls Ferry Missouri, houses for rent Halls Ferry Missouri, and homes for rent in Halls Ferry
Identify, ferret out, and distinguish for rent by owner homes Dade, Dade Missouri vacation rentals, rent houses Dade, and rental apartment in Dade.
Pre-rented private vacation home, lakefront villa, well appointed condominium, and exclusive villa are immediate in the nearly parcel of Gravois Missouri.
Disclose and find real estate rentals and apartment rentals Wellington United States.
See city indexes and exclusive listings that property owners and real estate investors post on our webpage.
Glimpse, find, and learn homes for rent in Ozark Missouri and vacation rental.
Conceive, light upon, and recognize rent houses Dunklin, Dunklin Missouri for rent by owner homes, rent houses in Dunklin, and rental home in Dunklin.
Perceive, relocate, and perceive homes for rent by owner Sheridan United States, rental houses Sheridan, and Sheridan United States bed and breakfast rentals.
Hear and explore vacation rental and rent houses in Wolf Island United States.
Perceive and locate vacation homes for rent by owner Leonard and houses for rent Leonard United States.
Learn and ferret out vacation homes for rent by owner in Mill Spring United States and vacation homes Mill Spring.
Wanderers and wanderers scan, hunt, and smell around this webpage and uncover ski in/out condominium, log vacation home, studio flat, and hillside castle.
Discover and ascertain rent house in King City United States and bed and breakfast rentals in King City.
Move, glimpse, and originate apartment rentals Rocky Mount United States, condo rentals, and vacation homes for rent by owner.
Identify, disclose, and debunk Stover United States apartments for rent, Stover bed and breakfast rentals, and bed and breakfast rentals in Stover United States.
Gravois Missouri is a nice and pleasing turf with marvelous, bewitching, and enticing condominium, hacienda, and ranchs.
Devise and ferret out High Ridge United States rental apartment and High Ridge United States rental home.
Devise, determine, and conceive Platte City United States homes for rent, apartment rentals in Platte City United States, and rental properties Platte City.
Dig up and devise holiday rentals in Cedar Missouri, rental apartment Cedar Missouri, and short term rentals Cedar Missouri.
We established and built FRBO.com to be delightful, refined, magnificent, and bewitching.
Contrive and disclose short term rentals Lamar United States and homes for rent by owner in Lamar.
Come across and find Clarence houses for rent and vacation rentals in Clarence United States.
Originate and discern home rentals and Belleview real estate rentals.
Locate, elicit, and devise condo rentals in Hume United States, bed and breakfast rentals in Hume United States, and vacation rentals Hume.
Hear, discover, and find Howell Missouri vacation rental, rent houses Howell, home rentals in Howell Missouri, and house rentals in Howell.
Conceive and ferret out vacation rental in Camden Missouri and real estate rentals in Camden.
Gravois Missouri circumstances could bail out, open doors, and back your inquiry.
This site, For Rent By Owner (FRBO.com) does accommodate special spacious, secluded, and waterfront cottage, chalet, timeshare, and lodges.
Our for rent by owner site, FRBO.com comprises area and precinct testimony, by ordinary.
Gravois property managers and agents serving the condo market list Gravois vacation homes, vacation homes in Gravois Missouri, and rent house Gravois Missouri.
Relocate strange, distinct, distinct, and distinct circumstances in Gravois and classify rental houses Gravois Missouri.
Catch, hear, and contrive homes for rent Webster, home rentals in Webster, and apartment rentals in Webster.
Find out, design, and distinguish homes for rent by owner, house rentals, and home rentals Hannibal.
Recognize, glimpse, and come upon Ripley short term rentals and Ripley vacation homes for rent by owner.
Determine, locate, and uncover rental home in Caldwell, bed and breakfast rentals, and vacation homes for rent by owner Caldwell.
Design, espy, and uncover Harrison for rent by owner homes, Harrison vacation rentals, and condo rentals in Harrison.
Get, recruit, and draft now to lead off, launch, and lead off on this vagrancy.
Not seldom, benefit and further your brothers and sailors to a mungo and humungous domain.
Discern and come across rental houses Hickory, rental properties in Hickory, vacation homes Hickory Missouri, and Hickory Missouri condo rentals.
Dwellers and globetrotters who are wishing to relocate and catch or simply detect information can use FRBO.Com, For Rent By Owner,.
Join our waterfront listed properties, exclusive listed properties, loft ad directories, and rustic listings mailing list for vacation homes in Gravois Missouri, condos for rent in Gravois, and Gravois Missouri holiday rentals.
Gravois Missouri township employs many home owners, landlords, property agents, and rental property owners.
Glimpse and move St. Charles real estate rentals and homes for rent St. Charles Missouri.
FRBO.Com, For Rent By Owner, can recruit, serve, and obtain spacious ad directories, rustic lists of marked properties, spacious ads, and rustic advertisements lake ad directories, beach classified ads, log advertisements, and rustic lists of marked properties to stump your Gravois quest.
|
|
