|
<%@ 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
Maumee Ohio homes for rent and vacation homes for rent by owner Maumee
Whitehall rental homes, Whitehall Ohio rent house, and homes for rent
South Euclid Ohio rent house, rent house in South Euclid Ohio, rental houses South Euclid Ohio, and South Euclid Ohio house rentals
Streetsboro Ohio for rent by owner homes and apartments for rent in Streetsboro Ohio
Vacation rentals, Miami Ohio vacation homes for rent by owner, and real estate rentals in Miami Ohio
Homes for rent in Clayton, Clayton homes for rent by owner, Clayton apartments for rent, and rental apartment Clayton Ohio
Mad River rent houses and Mad River Ohio bed and breakfast rentals
House rentals in Whitehall Ohio, Whitehall Ohio vacation homes, and vacation homes for rent by owner Whitehall Ohio
Rent house in Prairie Ohio, vacation rental Prairie Ohio, Prairie holiday rentals, and Prairie Ohio holiday rentals
Short term rentals in Cleveland Heights Ohio and house rentals
House rentals Dover Ohio, rental apartment, and condo rentals Dover
Short term rentals Circleville, vacation homes, vacation homes Circleville, and homes for rent by owner Circleville
The Newark ski in/out advertisements, hillside classifieds, and beach classifieds for these city can be mapped.
Move, look up, and distinguish vacation homes for rent by owner Columbiana, apartment rentals in Columbiana, condos for rent in Columbiana Ohio, and Columbiana Ohio rental properties.
This site, FRBO.com can procure and get hillside lists of marked properties, lake listed properties, and hidden indexes resort classified ads, resort classified advertisements, city lists of marked properties, and resort listings to sustain your Newark Ohio expedition.
Learn and catch Lake Ohio bed and breakfast rentals and Lake Ohio rental homes.
Come upon, find out, and perceive vacation rental in Risingsun, vacation rental in Risingsun United States, and Risingsun United States house rentals.
Learn and uncover real estate rentals and Anna United States rental houses.
Disclose and glimpse rental homes Fairfield, Fairfield Ohio vacation homes for rent by owner, and Fairfield Ohio rental apartment.
Newark Ohio dope could stump, work with, ballyhoo, and expedite your research.
Look up, contrive, and glimpse vacation rentals, Williams rental apartment, and Williams short term rentals.
Explore and devise rent houses in West Unity United States and West Unity United States rent house.
Newark is a statuesque and pretty zone with comely and charming cabin, bungalow, house, and haciendas.
Discover, uncover, and disclose Fredericksburg United States homes for rent by owner, Fredericksburg United States houses for rent, and Fredericksburg rental houses.
Espy, move, and invent condos for rent Barberton United States, houses for rent in Barberton United States, and Barberton vacation rental.
The Newark Ohio listed properties registered and billed on For Rent By Owner enclose mountain ranch, lake home, ski in/out apartment, and studio apartment.
Ascertain, espy, and contrive vacation rental in Coshocton, Coshocton Ohio rental properties, and rental properties in Coshocton.
|
|
