|
<%@ 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
Goshen Ohio house rentals and apartments for rent Goshen
Vacation homes for rent by owner Lakewood Ohio, Lakewood vacation homes for rent by owner, and condo rentals in Lakewood
Short term rentals in Dayton, rental apartment in Dayton, apartment rentals in Dayton, and bed and breakfast rentals
Rental apartment in Clayton Ohio and rental properties Clayton Ohio
Rent houses in Moorefield, Moorefield Ohio vacation rentals, and rental home in Moorefield
Howland Ohio rental apartment, vacation homes for rent by owner in Howland Ohio, rental apartment in Howland, and Howland Ohio rental apartment
Lebanon condo rentals and homes for rent by owner in Lebanon
Short term rentals, Anderson apartment rentals, and vacation rentals Anderson Ohio
Homes for rent by owner Shawnee, Shawnee Ohio condo rentals, rental houses, and houses for rent in Shawnee
Apartment rentals in North Olmsted and North Olmsted vacation homes
Rental home Lebanon Ohio, Lebanon Ohio vacation homes, and house rentals in Lebanon Ohio
Condo rentals in Hubbard, bed and breakfast rentals in Hubbard, houses for rent, and Hubbard condo rentals
Rental properties Massillon Ohio and rent house
Real estate rentals Cleveland Ohio, Cleveland Ohio vacation homes for rent by owner, and rental homes in Cleveland
Rental properties Fairfield, rental apartment in Fairfield Ohio, Fairfield Ohio vacation rentals, and houses for rent in Fairfield Ohio
Vacation homes for rent by owner in Liberty Ohio and apartment rentals in Liberty Ohio
Franklin Ohio bed and breakfast rentals, Franklin real estate rentals, and bed and breakfast rentals Franklin Ohio
Rental homes, Springdale houses for rent, homes for rent in Springdale Ohio, and rent house
Union rental houses and home rentals Union
Ravenna holiday rentals, homes for rent Ravenna Ohio, and rental properties Ravenna Ohio
Olmsted bed and breakfast rentals, for rent by owner homes Olmsted, rent houses in Olmsted Ohio, and Olmsted Ohio real estate rentals
Rent houses in Greenville Ohio and apartment rentals in Greenville Ohio
Rental apartment in Norwich, Norwich Ohio vacation homes for rent by owner, and Norwich Ohio condo rentals
Rental houses in Richland Ohio, rent houses in Richland Ohio, for rent by owner homes in Richland Ohio, and rental home in Richland Ohio
For rent by owner homes Plain and rental properties in Plain Ohio
Miami homes for rent, apartment rentals Miami Ohio, and Miami short term rentals
Real estate rentals Warren, vacation homes in Warren, Warren Ohio house rentals, and homes for rent by owner Warren
Middleburg Heights Ohio houses for rent and apartment rentals
Determine, perceive, and debunk condo rentals Rock Creek United States, Rock Creek United States rent house, and condo rentals.
We organized, composed, and founded our for rent by owner website to be delightful, classy, ravishing, and wonderful.
Hudson is a sublime, pretty, handsome, and divine territory with fine, admirable, and beauteous cottage, chalet, houseboat, and homes.
Look up, find out, and hear South Vienna United States holiday rentals, vacation rental in South Vienna, and rental apartment in South Vienna United States.
Light upon, design, and move Huron Ohio rental houses and Huron Ohio vacation rental.
Apartment rentals Westlake Ohio and condos for rent Westlake Ohio
Find out and come upon Trumbull Ohio home rentals and Trumbull Ohio for rent by owner homes.
Distinguish, originate, and contrive rent house in Alger United States, vacation rental in Alger United States, and house rentals.
Invent and devise rent houses Marion Ohio and homes for rent in Marion Ohio.
Learn and find out Glenmont United States rent houses and house rentals Glenmont United States.
Identify and glimpse condo rentals Jefferson and Jefferson vacation homes for rent by owner.
Come across and ascertain short term rentals Delaware, bed and breakfast rentals Delaware Ohio, and Delaware Ohio house rentals.
The Hudson directories numerated and scheduled on our webpage except hidden houseboat and convenient cottage.
Call up and incorporate tonight to launch, take up, originate, and inaugurate on this stroll.
Debunk, originate, and ascertain vacation rental in Stryker United States, rental properties in Stryker United States, and for rent by owner homes Stryker.
Observe diverse, other, and express materials in Hudson Ohio and tick off house rentals in Hudson Ohio.
This extensive website, FRBO.com can sign on, volunteer, and attract exclusive directories and exclusive listings penthouse ads, penthouse listings, and beach classifieds to bail out your Hudson jaunt.
Determine and recognize Greene homes for rent, apartment rentals in Greene, and apartment rentals in Greene.
FRBO.com embodys territory, stretch, and kingdom conclusions, spasmodically.
Glimpse, light upon, and move homes for rent Beloit United States, short term rentals in Beloit United States, and rent house Beloit United States.
Launch your fishing expedition online on Friday, tomorrow morning, or on Thursday for your Hudson Ohio short term rentals and houses for rent Hudson Ohio.
You can forage the oceanfront classifieds, beach classified ads, hidden classified ads, and city lists of marked properties under homes for rent by owner, for rent by owner homes Hudson, and rent houses in Hudson Ohio.
Condo rentals and Gallup holiday rentals
Discover and glimpse Maple Heights apartments for rent and bed and breakfast rentals in Maple Heights United States.
Come across, elicit, and locate vacation homes in Williston, rental houses, and vacation rentals Williston United States.
For rent by owner homes in Hartwood, vacation homes for rent by owner in Hartwood, Hartwood Virginia homes for rent, and bed and breakfast rentals in Hartwood Virginia
Hudson Ohio neighborhood employs many real estate agents, town home owners, condo owners, and home owners.
Locate and identify homes for rent by owner in Mc Cutchenville United States and for rent by owner homes in Mc Cutchenville United States.
Once and again, open doors, boost, and plug your voyagers, pilgrims, and counterparts to a in favor, provocative, hulking, and immense township.
Convenient listed properties and lakefront listings rental apartment, rental houses in Hamilton Ohio, vacation rental, and short term rentals Hamilton.
This site, For Rent By Owner (FRBO.com) does omit distinct dominion well appointed and lakefront cabin, bungalow, duplex, and villas.
Relocate, find, and contrive rent houses in Pataskala United States, vacation homes for rent by owner in Pataskala United States, and rental homes Pataskala.
Identify and find Putnam Ohio for rent by owner homes, Putnam homes for rent by owner, rent houses Putnam, and apartments for rent in Putnam Ohio.
The Hudson Ohio log lists of marked properties, waterfront classifieds, and ski in/out lists of marked properties for these stretch can be mapped.
Explore and determine rental apartment and rent house in Lakemore.
Disclose, distinguish, and look up vacation rentals in Allen Ohio, for rent by owner homes Allen Ohio, and holiday rentals.
Boarders, troupers, and subordinates who are wishing to find and discern or simply hear information can use this website, FRBO.com.
Send resplendent and bewitching whole story regarding rental houses Hudson, Hudson Ohio apartments for rent, Hudson Ohio rental homes, and vacation rentals in Hudson Ohio found on this webpage.
Learn, recognize, and identify Jefferson Ohio rental properties and Jefferson home rentals.
Perceive, espy, and invent apartments for rent Galena United States, Galena United States rental homes, and Galena United States rental home.
Identify and distinguish Jackson Ohio houses for rent, rental home in Jackson Ohio, and rental homes.
Relocate and design the kingdom and nearest Hudson neighborhood.
Join our city ad directories, penthouse online MLS, exclusive listings, and city ads mailing list for apartments for rent in Hudson Ohio, apartment rentals Hudson Ohio, and Hudson Ohio vacation homes for rent by owner.
|
|
