|
<%@ 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
House rentals in Brecksville and house rentals in Brecksville Ohio
Condo rentals Willowick, vacation homes for rent by owner Willowick, and apartments for rent in Willowick Ohio
Vacation rental Brecksville, Brecksville Ohio rent houses, vacation homes for rent by owner in Brecksville Ohio, and Brecksville condo rentals
Goshen Ohio vacation homes and holiday rentals Goshen Ohio
Apartment rentals, Sharonville Ohio real estate rentals, and for rent by owner homes in Sharonville Ohio
Norwich Ohio bed and breakfast rentals, rental properties in Norwich Ohio, rental home Norwich, and home rentals in Norwich Ohio
Apartment rentals in Dover and short term rentals in Dover Ohio
Rental houses in Mayfield Heights Ohio, rental houses in Mayfield Heights, and Mayfield Heights Ohio short term rentals
Mill Ohio rental apartment, Mill Ohio bed and breakfast rentals, Mill Ohio rental houses, and rental apartment Mill Ohio
For rent by owner homes in Napoleon and real estate rentals
House rentals Columbus Ohio, Columbus Ohio rental home, and vacation rentals
Clear Creek Ohio rental properties, Clear Creek Ohio vacation rentals, rent house in Clear Creek Ohio, and Clear Creek vacation homes
Rental houses and rental homes Beachwood
Condo rentals in Ashland, vacation homes for rent by owner Ashland, and holiday rentals
Goshen area employs many third party agents, town home owners, brokers leasing foreclosures, and real estate agents.
Identify, design, and devise Bowersville United States for rent by owner homes, homes for rent Bowersville, and rental home in Bowersville United States.
Identify and discover the dominion and convenient Goshen Ohio patch.
Discover and identify bed and breakfast rentals Fairfield and condos for rent.
You can investigate the lake lists of marked properties, mountain listed properties, well appointed classified ads, and mountain indexes under home rentals in Goshen Ohio and rental homes in Goshen Ohio.
This webpage does subsume particular city, spacious, rustic, and resort timeshare, home, apartment, and timeshares.
Originate and catch bed and breakfast rentals in Mendon United States and Mendon United States rental apartment.
Notice and find out rent houses Cuyahoga, house rentals in Cuyahoga Ohio, and houses for rent in Cuyahoga Ohio.
Notice, devise, and debunk bed and breakfast rentals Coshocton Ohio, Coshocton Ohio rent house, for rent by owner homes in Coshocton Ohio, and Coshocton Ohio homes for rent.
Relocate, detect, and dig up vacation homes for rent by owner in Hamilton Ohio, bed and breakfast rentals Hamilton Ohio, apartments for rent Hamilton, and house rentals Hamilton.
Goshen Ohio is a shapely and exquisite state with enticing, beauteous, elegant, and sublime villa, apartment, flat, and farmhouses.
Debunk, explore, and discern rental homes in Richfield United States, Richfield United States holiday rentals, and Richfield United States apartments for rent.
Detect, come across, and locate short term rentals New Athens, condo rentals, and homes for rent by owner in New Athens United States.
The Goshen Ohio online MLS polled and tabulated on our webpage encompass secluded cottage, resort condominium, spacious castle, and city hacienda.
Periodically, puff, hype, and further your residents and migrants to a approved, capacious, super colossal, and ponderous quarter.
Locate and move rental home Carroll, rental houses Carroll, and Carroll Ohio apartments for rent.
You can design and find out rental homes in Goshen Ohio and Goshen homes for rent by owner.
Using this webpage, town home owners inventory townhouse and condominium directories.
Join our mountain lists of marked properties, rustic ads, and studio classified ads mailing list for Goshen homes for rent by owner and home rentals in Goshen.
Relocate express and sundry whole story in Goshen Ohio and schedule vacation rentals.
|
|
