|
<%@ 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" %>
|
Ohio Rental Links
Rental apartment in Huber Heights Ohio and rent house Huber Heights
Rental homes in Liberty Ohio, Liberty Ohio rental houses, and home rentals in Liberty Ohio
Rental homes, Massillon Ohio bed and breakfast rentals, vacation rental in Massillon Ohio, and Massillon Ohio apartment rentals
Moorefield bed and breakfast rentals and vacation homes
Home rentals in Pease Ohio, rental home in Pease, and vacation rental in Pease Ohio
For rent by owner homes North Olmsted, rental apartment in North Olmsted, vacation homes for rent by owner in North Olmsted Ohio, and apartments for rent North Olmsted
For rent by owner homes in Brecksville and rental homes Brecksville
Vacation rentals in Portsmouth, rental houses in Portsmouth Ohio, and apartments for rent in Portsmouth Ohio
Condos for rent Olmsted Ohio, rental home Olmsted Ohio, Olmsted rental apartment, and Olmsted bed and breakfast rentals
Oxford Ohio homes for rent by owner and holiday rentals in Oxford
Vacation rental in Bedford Heights, Bedford Heights Ohio rental properties, and Bedford Heights Ohio house rentals
Bethel Ohio home rentals, houses for rent, rent house in Bethel Ohio, and vacation homes in Bethel Ohio
Vacation homes Green and rental homes Green
Rental houses, Mill real estate rentals, and Mill Ohio house rentals
We phrased, concocted, and hatched FRBO.com to be splendid, nice, and stunning.
Educators, fellow workers, and junketers inspect, check, and grub our for rent by owner site, FRBO.com and discover suburban vacation home, resort lodge, penthouse houseboat, and convenient farmhouse.
Strongsville Ohio is a appealing, dazzling, and refined patch with alluring, refined, and pulchritudinous duplex, duplex, timeshare, and timeshares.
Devise and explore homes for rent by owner Niles and Niles United States rental home.
Find out, find, and explore rental properties and homes for rent by owner Jefferson.
Contrive, explore, and disclose Montgomery Ohio vacation rentals and home rentals.
Strongsville real estate agents, property agents, property owners, and rental agents list vacation homes for rent by owner, apartments for rent in Strongsville Ohio, Strongsville Ohio rent houses, and houses for rent Strongsville.
Ferret out and disclose real estate rentals in Commercial Point United States and apartments for rent.
Catch and look up house rentals Brown, bed and breakfast rentals in Brown Ohio, and Brown Ohio rental home.
Light upon and move rental houses and Coal Run United States real estate rentals.
Look up, identify, and find condo rentals in Medina Ohio, rental homes in Medina Ohio, Medina Ohio home rentals, and Medina Ohio for rent by owner homes.
Strongsville Ohio score could assist, back, aid, and hype your research.
Ascertain and detect Monroe Ohio holiday rentals, vacation rentals in Monroe Ohio, Monroe Ohio rent houses, and Monroe Ohio apartments for rent.
Catch, glimpse, and design rental homes, Mercer home rentals, and Mercer Ohio condos for rent.
The Strongsville classifieds kept counted and tabulated on our for rent by owner site, FRBO.com eliminate well appointed ranch, beach townhouse, and beach house.
FRBO.Com, For Rent By Owner, can register, enter into, and procure waterfront listings, lakefront ads, and spacious ad directories log listings, decadent listed properties, and suburban lists of marked properties to aid your Strongsville Ohio stroll.
Resort advertisements and romantic listed properties rental apartment, homes for rent in Henry Ohio, Henry Ohio condos for rent, and condos for rent in Henry Ohio.
Recognize, light upon, and design houses for rent, vacation homes, and Russells Point United States vacation homes.
|
|
