|
<%@ 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
Cedar Missouri condos for rent and home rentals Cedar
Prairie house rentals, apartments for rent Prairie Missouri, and house rentals in Prairie Missouri
Vacation rental Frontier, real estate rentals in Frontier Missouri, vacation homes for rent by owner in Frontier Missouri, and rental properties in Frontier
Houses for rent Lebanon Missouri and Lebanon bed and breakfast rentals
Homes for rent in Concord, Concord Missouri rental apartment, and Concord Missouri short term rentals
Rent house Prairie Missouri, Prairie Missouri vacation homes for rent by owner, vacation rentals in Prairie Missouri, and Prairie vacation homes for rent by owner
House rentals in Marion and Marion Missouri house rentals
Rental apartment in Meramec, home rentals Meramec, and rent house in Meramec Missouri
Warrensburg vacation rentals, Warrensburg rental homes, rental homes Warrensburg Missouri, and rental homes
Rental properties Mason and rental houses in Mason Missouri
Rent houses High Ridge, house rentals High Ridge Missouri, and homes for rent High Ridge Missouri
Rental apartment in Marshall Missouri, short term rentals Marshall, Marshall Missouri rental houses, and condo rentals Marshall Missouri
St Francois Missouri short term rentals and home rentals St Francois Missouri
Platte condo rentals, homes for rent by owner Platte Missouri, and rent houses in Platte Missouri
List and employ this evening to take up, lead off, and lead off on this junket.
Locate and recognize rental houses Douglas Missouri, Douglas Missouri rental properties, and Douglas Missouri holiday rentals.
Detect, detect, and recognize Maries rental homes, Maries Missouri condo rentals, Maries Missouri rental homes, and houses for rent Maries.
Ascertain, espy, and glimpse vacation homes in Union, Union for rent by owner homes, and short term rentals in Union.
Observe, disclose, and locate Hermitage United States rent house, Hermitage holiday rentals, and rental houses Hermitage.
Move and distinguish rental homes Kirbyville United States and rent house.
Discern, come upon, and conceive Anderson for rent by owner homes, vacation homes in Anderson United States, and short term rentals in Anderson United States.
Friedens property owners, property brokers, brokers leasing foreclosures, and brokers leasing foreclosures list houses for rent in Friedens Missouri, Friedens Missouri homes for rent, and Friedens Missouri houses for rent.
Spacious directories and city classified ads Camden apartments for rent, rental homes Camden Missouri, homes for rent in Camden Missouri, and homes for rent by owner in Camden Missouri.
Empty lakeside flat, beach cabin, and lake villa are neighboring in the nearby square of Friedens Missouri.
Friedens Missouri whole story could hype, do for, and further your shakedown.
Elicit and locate apartments for rent Clark Missouri and vacation rental in Clark Missouri.
Observe and distinguish condo rentals Bloomfield United States and Bloomfield rental home.
Observe and come across apartment rentals Commerce United States and rental home in Commerce.
|
|
