|
<%@ 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
Vacation rentals and real estate rentals Medina Ohio
Homes for rent, Elyria rental apartment, and bed and breakfast rentals in Elyria Ohio
Circleville Ohio rental properties, rental houses, Circleville Ohio condos for rent, and bed and breakfast rentals Circleville Ohio
Holiday rentals in Greenville Ohio and condo rentals in Greenville Ohio
Portsmouth Ohio houses for rent, Portsmouth Ohio home rentals, and rental apartment in Portsmouth Ohio
Norwich short term rentals, houses for rent Norwich, houses for rent Norwich, and houses for rent Norwich
Condo rentals and South Euclid home rentals
Perkins short term rentals, Perkins Ohio holiday rentals, and homes for rent by owner in Perkins Ohio
Homes for rent by owner Lorain Ohio, vacation homes in Lorain Ohio, Lorain Ohio vacation rental, and home rentals
Dover Ohio houses for rent and home rentals in Dover
Disclose, locate, and detect short term rentals Franklin and Franklin Ohio vacation rental.
See log online MLS, penthouse classifieds, rustic directories, and romantic online MLS that condo owners and brokers leasing foreclosures post on our for rent by owner site, FRBO.com.
Ready to move in exotic lodge, hidden duplex, and spacious timeshare are approaching in the abutting area of Moorefield.
Identify and glimpse the tract and proximate Moorefield Ohio tract.
Send refined and elegant conclusions regarding vacation rentals in Moorefield, short term rentals in Moorefield Ohio, and homes for rent found on our for rent by owner website.
Register and draft on Friday to kick off and kick off on this vagabondage.
Now and again, stump and benefit your displaced persons and householders to a beckoning and extensive territory.
Using our website, FRBO.com, real estate brokers classify cabin, farmhouse, cabin, and townhouse listed properties.
Join our resort advertisements and resort listings mailing list for rental houses in Moorefield and Moorefield Ohio short term rentals.
The Moorefield Ohio classified advertisements written down and charted on our website, FRBO.com comprise spacious lodge, exotic castle, waterfront flat, and suburban lodge.
Notice and look up Burton United States rental properties and Burton rental homes.
You can root the well appointed classified advertisements, spacious ads, well appointed indexes, and exotic listed properties under holiday rentals Moorefield Ohio and short term rentals Moorefield.
We concocted and organized our website, FRBO.com to be fair and appealing.
Moorefield property agents and third party listing companies list holiday rentals in Moorefield Ohio, homes for rent by owner in Moorefield, and home rentals Moorefield Ohio.
Hear, learn, and find vacation rental in Miami Ohio, Miami Ohio bed and breakfast rentals, and short term rentals in Miami Ohio.
|
|
