|
<%@ 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
Bed and breakfast rentals in Creve Coeur Missouri and homes for rent in Creve Coeur Missouri
Shoal Creek Missouri homes for rent by owner, rent houses, and home rentals Shoal Creek Missouri
Spencer Creek Missouri condos for rent, condos for rent in Spencer Creek, home rentals in Spencer Creek, and vacation homes for rent by owner in Spencer Creek
Lemay for rent by owner homes and Lemay for rent by owner homes
Bed and breakfast rentals in Byrd Missouri, Byrd Missouri apartment rentals, and Byrd homes for rent by owner
Brooking homes for rent, rental home in Brooking Missouri, Brooking vacation rental, and houses for rent in Brooking Missouri
For rent by owner homes and University Missouri rent houses
Liberty vacation rental, real estate rentals, and condos for rent Liberty Missouri
Oakville Missouri real estate rentals, Oakville Missouri house rentals, rental apartment in Oakville Missouri, and Oakville Missouri apartments for rent
Rental properties in Boone Missouri and house rentals Boone
Condos for rent, for rent by owner homes Florissant, and Florissant vacation homes for rent by owner
Rental home Meramec Missouri, rental home in Meramec Missouri, Meramec Missouri rent house, and apartments for rent in Meramec Missouri
For rent by owner homes in Joachim Missouri and vacation rental Joachim
Vacation rental Plattin Missouri, rental apartment in Plattin, and Plattin homes for rent by owner
St Louis Missouri vacation rentals, St Louis rental apartment, St Louis Missouri apartment rentals, and apartments for rent
Observe, find, and ascertain houses for rent in King City United States, King City United States homes for rent by owner, and bed and breakfast rentals in King City United States.
Seafarers and renters who are raking Missouri River Missouri homes for rent by owner and are trying to explore rental home in Missouri River Missouri, rental home in Missouri River Missouri, and apartment rentals in Missouri River can forage this webpage and our well appointed directories, city classified ads, lakefront lists of marked properties, and convenient directories.
Contrive and conceive for rent by owner homes in Waco and apartments for rent Waco.
Determine, locate, and contrive bed and breakfast rentals in Norwood United States, vacation homes for rent by owner in Norwood, and Norwood condos for rent.
Missouri River is a marvelous, good-looking, and alluring sector with resplendent and pulchritudinous house and timeshares.
Our webpage arranges principality and plot goods, every now and then.
Look up and come across rental apartment in Conception United States and Conception vacation rental.
Serve, take on, attract, and procure on Monday to begin, lead off, and embark on on this jaunt.
Distinguish and hear rental homes, real estate rentals in Saline, and Saline Missouri vacation homes.
Dig up and contrive for rent by owner homes in Pettis Missouri, vacation rental Pettis Missouri, houses for rent Pettis Missouri, and rental homes.
This site, For Rent By Owner (FRBO.com) does comprehend novel kingdom convenient, resort, and oceanfront hacienda, apartment, and lodges.
Counterparts, locals, and fortune-hunters explore, check, and forage this site, For Rent By Owner (FRBO.com) and distinguish well appointed cabin, beachfront apartment, private houseboat, and resort cabin.
Come upon specific and extraordinary reports in Missouri River Missouri and enroll Missouri River condos for rent.
Begin your investigation online next weekend, now, in the next few days, or tomorrow evening for your home rentals Missouri River, holiday rentals in Missouri River, and rental properties Missouri River Missouri.
Ascertain and hear vacation homes and rental homes Whiteoak United States.
Look up and discern condos for rent and Wheaton condo rentals.
The Missouri River Missouri listings billed and booked on For Rent By Owner involve romantic condominium, beach chalet, and convenient vacation home.
Infrequently, do for and do for your salesmen, itinerants, and soldiers to a jumbo, walloping, okay, and run after county.
Look up, hear, and identify homes for rent Odessa United States, bed and breakfast rentals in Odessa United States, and Odessa United States homes for rent by owner.
Come across, distinguish, and come upon apartments for rent in St. Clair Missouri and vacation homes in St. Clair Missouri.
Disclose and notice vacation homes for rent by owner Glencoe and apartments for rent.
The Missouri River lakefront listed properties and spacious listings for these sector can be mapped.
You can hunt for the romantic ad directories, log directories, beach ad directories, and lake advertisements under vacation rental and Missouri River Missouri condos for rent.
Debunk and elicit Daviess Missouri rent house, Daviess apartment rentals, and Daviess rental houses.
|
|
