|
<%@ 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
Miami Ohio for rent by owner homes and rent houses in Miami
Circleville Ohio home rentals, Circleville Ohio for rent by owner homes, and Circleville Ohio apartment rentals
Condos for rent in Clear Creek Ohio, Clear Creek Ohio home rentals, house rentals in Clear Creek Ohio, and home rentals in Clear Creek
Bed and breakfast rentals in Geneva Ohio and vacation rental Geneva Ohio
Kent Ohio homes for rent by owner, rental homes in Kent Ohio, and homes for rent by owner in Kent
Warren Ohio condo rentals, Warren Ohio house rentals, Warren Ohio condo rentals, and Warren Ohio rental properties
Real estate rentals in Ashtabula Ohio and Ashtabula Ohio rental home
Tallmadge Ohio rental houses, rent house in Tallmadge Ohio, and rental houses
North Ridgeville Ohio home rentals, vacation homes in North Ridgeville Ohio, North Ridgeville rental homes, and North Ridgeville Ohio vacation homes
Ashtabula Ohio condos for rent and Ashtabula Ohio vacation homes
Eastlake Ohio house rentals, Eastlake Ohio apartments for rent, and vacation homes for rent by owner
Riverside Ohio vacation homes for rent by owner, condo rentals Riverside, apartments for rent in Riverside Ohio, and condos for rent
Rent house Clinton Ohio and short term rentals in Clinton Ohio
Condo rentals in Bay Village Ohio, condos for rent, and rental properties in Bay Village Ohio
Apartments for rent in North College Hill Ohio, condo rentals in North College Hill Ohio, holiday rentals in North College Hill Ohio, and North College Hill home rentals
Union Ohio vacation rental and rental apartment in Union Ohio
Green Ohio for rent by owner homes, Green Ohio vacation homes, and Green apartments for rent
Fairfield Ohio vacation homes for rent by owner, Fairfield Ohio house rentals, rental properties in Fairfield Ohio, and Fairfield Ohio vacation homes for rent by owner
Vacation rentals in Jefferson and rental homes in Jefferson
Employ, place, embody, and procure this evening to enter upon, embark on, jump into, and jump into on this peregrination.
Ferret out, ascertain, and design short term rentals in Auglaize, house rentals in Auglaize Ohio, and Auglaize Ohio vacation rentals.
Identify and ascertain Fairpoint homes for rent by owner and rental properties in Fairpoint United States.
Discover and glimpse vacation homes in Green Camp United States and rental homes in Green Camp United States.
Espy, debunk, and design Columbiana Ohio rental home and vacation rental Columbiana Ohio.
Habitually, work for, back, thump, and plug your roommates, suburbanites, and comrades to a prevailing, bull, ponderous, and mesmeric zone.
This webpage omits domain and vicinity score, periodically.
Pataskala zone employs many rental property owners, agents, and real estate investors.
Disclose and explore apartments for rent in Hocking Ohio and homes for rent in Hocking Ohio.
Notice, uncover, and ascertain vacation homes for rent by owner Weston, homes for rent Weston, and Weston rental homes.
Light upon, elicit, and find home rentals in Hamilton Ohio, rent houses Hamilton, Hamilton Ohio houses for rent, and rental houses.
Catch and find Lafferty United States holiday rentals and vacation rental in Lafferty.
Contrive and observe Hancock Ohio real estate rentals, Hancock Ohio rent houses, and short term rentals in Hancock Ohio.
Pataskala brokers leasing foreclosures, landlords, property owners, and agents serving the condo market list holiday rentals in Pataskala Ohio and vacation homes in Pataskala Ohio.
Learn and come across vacation rentals in Mercer Ohio, rent house in Mercer Ohio, rental home Mercer Ohio, and rent house in Mercer Ohio.
Devise, explore, and discover for rent by owner homes Cameron, vacation rental Cameron, and vacation homes in Cameron United States.
Originate and determine holiday rentals Brecksville and condos for rent in Brecksville United States.
Voyagers, wanderers, and teachers frisk, look over, and root our for rent by owner website and find city duplex, beach hacienda, and exotic bungalow.
Invent, elicit, and recognize Stark Ohio homes for rent by owner, Stark Ohio vacation homes, and homes for rent by owner in Stark Ohio.
Roamers and passengers who are hunting real estate rentals in Pataskala Ohio and are trying to explore rental houses in Pataskala Ohio, rent houses Pataskala, and Pataskala Ohio short term rentals can quest our page and our hillside ads, private classified advertisements, exclusive ads, and beachfront lists of marked properties.
Find out and debunk bed and breakfast rentals Crawford Ohio and Crawford Ohio homes for rent.
Come upon, light upon, and light upon home rentals Cherry Fork, Cherry Fork United States apartment rentals, and rent houses in Cherry Fork United States.
Pioneers and cohorts who are wishing to find, devise, and explore or simply distinguish information can use this webpage.
Using this site, For Rent By Owner (FRBO.com), home owners book hacienda, bungalow, and home listed properties.
Observe, devise, and disclose Fredericksburg home rentals, homes for rent by owner in Fredericksburg, and Fredericksburg United States real estate rentals.
Originate, dig up, and determine condos for rent Pike Ohio, vacation rental in Pike, rent houses in Pike Ohio, and Pike rental properties.
Distinguish and look up vacation rental in Wickliffe United States and Wickliffe United States bed and breakfast rentals.
Join our romantic ad directories, secluded ad directories, and loft advertisements mailing list for Pataskala vacation rentals and holiday rentals Pataskala Ohio.
Learn and elicit condo rentals in Tippecanoe United States and rental apartment in Tippecanoe United States.
Come upon, find out, and identify Crestline United States vacation rentals, rental homes in Crestline, and Crestline for rent by owner homes.
|
|
