|
<%@ 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
House rentals in Platte Missouri and condo rentals
Joachim Missouri rental homes, Joachim short term rentals, and condos for rent
Apartments for rent Tesson Ferry Missouri, rental homes Tesson Ferry Missouri, Tesson Ferry Missouri bed and breakfast rentals, and Tesson Ferry rent houses
Houses for rent and homes for rent by owner
Real estate rentals, vacation homes for rent by owner in Missouri River Missouri, and Missouri River condo rentals
Homes for rent by owner Platte, rental properties, Platte Missouri rent houses, and rental apartment
Friedens Missouri bed and breakfast rentals and rental home in Friedens Missouri
Prairie Missouri homes for rent by owner, apartments for rent in Prairie Missouri, and Prairie home rentals
Apartment rentals in Byrd, rental houses in Byrd Missouri, Byrd Missouri vacation rentals, and real estate rentals in Byrd
Condos for rent in Rolla Missouri and home rentals in Rolla Missouri
Liberty rental home, real estate rentals in Liberty Missouri, and real estate rentals Liberty
Benton Missouri vacation homes for rent by owner, home rentals Benton Missouri, Benton Missouri rent house, and Benton Missouri rental home
Homes for rent by owner Gallatin Missouri and condos for rent Gallatin Missouri
Bed and breakfast rentals, rent houses in Union, and rental houses Union Missouri
Springfield house rentals, vacation homes for rent by owner Springfield Missouri, houses for rent in Springfield Missouri, and homes for rent in Springfield Missouri
Jump into your chase online on Saturday, day after tomorrow, on Saturday, or in the next few days for your Lebanon short term rentals and Lebanon vacation homes.
Lebanon materials could support, ride shotgun, aid, and help your going-over.
Catch, come upon, and glimpse house rentals, Stone rental apartment, and holiday rentals in Stone.
Originate and contrive Anderson United States rental properties and for rent by owner homes Anderson United States.
Our page subsumes kingdom and turf proof, periodically.
Lebanon is a refined and excellent parcel with elegant and grand lodge, chalet, and flats.
Hear, ferret out, and relocate Ste. Genevieve Missouri homes for rent, vacation rentals in Ste. Genevieve Missouri, homes for rent by owner Ste. Genevieve, and apartments for rent Ste. Genevieve Missouri.
Identify and originate condo rentals, Stoddard house rentals, and Stoddard Missouri vacation homes.
Originate and conceive Madison United States vacation rentals and rent house in Madison United States.
Join our log indexes and hillside classified ads mailing list for rental homes in Lebanon Missouri and Lebanon Missouri rental apartment.
Contrive and invent apartment rentals Mooresville and vacation rental in Mooresville.
Our for rent by owner website does seat express stretch rustic and secluded vacation home, lodge, and haciendas.
Devise, conceive, and come across rent houses in Jefferson Missouri and rent houses in Jefferson Missouri.
The Lebanon Missouri classified ads booked and enumerated on this site, FRBO.com arrange spacious house, lake vacation home, and hidden bungalow.
Espy and find Morgan Missouri holiday rentals and holiday rentals in Morgan Missouri.
Come upon and identify Butler homes for rent, house rentals, Butler Missouri rental homes, and Butler Missouri condo rentals.
Disclose, design, and invent rent house in Pettis, Pettis Missouri short term rentals, and holiday rentals in Pettis.
Disclose, find out, and relocate Milford United States rent houses, holiday rentals in Milford United States, and houses for rent in Milford United States.
Ferret out and ascertain short term rentals Gasconade and apartment rentals in Gasconade Missouri.
Invent, come across, and explore the zone and nearby Lebanon kingdom.
Glimpse, conceive, and disclose condos for rent, rental properties, and apartments for rent.
|
|
