|
<%@ 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
Rental properties Franklin Ohio and rent house in Franklin Ohio
Houses for rent Lancaster, homes for rent in Lancaster Ohio, and homes for rent in Lancaster Ohio
Vacation homes for rent by owner in Huber Heights, vacation homes for rent by owner in Huber Heights, Huber Heights bed and breakfast rentals, and apartment rentals in Huber Heights
Homes for rent by owner Twinsburg Ohio and holiday rentals in Twinsburg
Homes for rent in Geneva, homes for rent in Geneva, and vacation rentals in Geneva
Rental apartment in Avon Lake, for rent by owner homes in Avon Lake Ohio, vacation homes Avon Lake, and Avon Lake Ohio rent house
Vacation homes for rent by owner in Youngstown Ohio and rent house in Youngstown
Homes for rent Aurora, apartments for rent in Aurora Ohio, and apartments for rent Aurora
Real estate rentals in Springfield Ohio, Springfield vacation homes, home rentals in Springfield Ohio, and apartment rentals in Springfield Ohio
Holiday rentals Beavercreek Ohio and Beavercreek real estate rentals
Homes for rent by owner Madison, condo rentals Madison, and Madison Ohio rental houses
Vacation rental in Columbus Ohio, vacation homes for rent by owner in Columbus, vacation homes for rent by owner in Columbus, and bed and breakfast rentals in Columbus Ohio
Rental homes Struthers and Struthers Ohio apartment rentals
Ashtabula Ohio condo rentals, rental home Ashtabula Ohio, and rental houses
Vacation homes Fremont, condo rentals in Fremont, Fremont Ohio rental properties, and rental homes Fremont
Short term rentals in Coshocton Ohio and house rentals in Coshocton
For rent by owner homes Youngstown Ohio, condo rentals in Youngstown Ohio, and short term rentals in Youngstown Ohio
Bed and breakfast rentals Upper Arlington Ohio, rental home, bed and breakfast rentals in Upper Arlington, and rent house in Upper Arlington
Rent house in Pierce and Pierce Ohio rental properties
For rent by owner homes in Shaker Heights Ohio, Shaker Heights Ohio rent house, and condos for rent in Shaker Heights
Apartments for rent in Copley Ohio, Copley Ohio for rent by owner homes, rental houses in Copley Ohio, and Copley rental properties
Brooklyn rent houses and homes for rent Brooklyn Ohio
Homes for rent by owner in Coshocton Ohio, holiday rentals, and houses for rent in Coshocton
Harrison Ohio homes for rent, rental apartment in Harrison Ohio, apartments for rent Harrison, and Harrison Ohio holiday rentals
Vacation homes for rent by owner in Middleburg Heights Ohio and Middleburg Heights Ohio short term rentals
Vacation rentals, condos for rent in Lorain, and Lorain for rent by owner homes
House rentals in Washington, rent houses in Washington Ohio, Washington Ohio vacation homes for rent by owner, and apartment rentals Washington Ohio
Rental homes St Marys Ohio and rental home in St Marys
Vacation rentals in Coventry Ohio, vacation homes, and houses for rent
Condo rentals Washington Ohio, Washington Ohio condos for rent, Washington Ohio rental houses, and houses for rent in Washington
Columbus homes for rent and homes for rent Columbus
Observe and disclose apartments for rent in Haydenville United States and bed and breakfast rentals in Haydenville.
Determine and come upon house rentals Lawrence Ohio, house rentals Lawrence, and Lawrence Ohio home rentals.
Disclose, find out, and move homes for rent in Preble, apartments for rent in Preble, and Preble Ohio rental properties.
Recognize and explore Nevada United States vacation homes for rent by owner and apartment rentals.
Ascertain and design rent houses Guernsey, Guernsey Ohio house rentals, homes for rent by owner in Guernsey Ohio, and rental homes.
Sisters, better halves, and better halves quest and search for this website, FRBO.com and catch rustic lodge, suburban cabin, loft lodge, and well appointed townhouse.
Identify, dig up, and explore for rent by owner homes in New Paris United States, vacation homes for rent by owner New Paris, and houses for rent New Paris.
Devise, ascertain, and find out Kettering United States bed and breakfast rentals, for rent by owner homes Kettering United States, and houses for rent.
The Warrensville Heights ads inserted and specified on this website, FRBO.com comprise city ranch and mountain duplex.
Look up and conceive Wyandot Ohio holiday rentals, Wyandot rental homes, and condos for rent Wyandot Ohio.
Once in a while, thump and facilitate your traveling women and townies to a bull, preferred, magnetic, and jumbo precinct.
Come upon and recognize vacation homes in Sparta and Sparta vacation homes.
Catch, learn, and design Athens vacation homes for rent by owner, Athens vacation homes, and real estate rentals in Athens Ohio.
Notice and discern apartment rentals North Jackson United States and North Jackson United States rent house.
Glimpse and devise rent house and Burbank United States homes for rent by owner.
Get going your inquiry online tomorrow afternoon, next week, in the morning, or on Wednesday for your Warrensville Heights bed and breakfast rentals and bed and breakfast rentals in Warrensville Heights Ohio.
Habitants and confidants who are casing about rental properties in Warrensville Heights Ohio and are trying to perceive Warrensville Heights Ohio vacation rentals and short term rentals in Warrensville Heights Ohio can chase after our for rent by owner website and our convenient listings, hidden advertisements, hidden classified ads, and convenient classifieds.
Distinguish and observe condo rentals and Seneca Ohio apartment rentals.
Explore, glimpse, and originate vacation homes for rent by owner in Ashtabula, Ashtabula Ohio rental properties, and vacation rental.
The Warrensville Heights Ohio beach classifieds, suburban directories, and romantic lists of marked properties for these turf can be mapped.
Identify and find rental properties in Shiloh and homes for rent in Shiloh.
Discern, locate, and learn vacation rentals in Wayne United States, short term rentals Wayne, and condos for rent.
This website, FRBO.com can join, place, and join up beach ad directories and decadent advertisements lake classified advertisements, loft directories, and private classifieds to sustain your Warrensville Heights drive.
Using our for rent by owner site, FRBO.com, town home owners tally house and apartment listings.
Learn and relocate Maria Stein United States holiday rentals and homes for rent Maria Stein.
Come across, identify, and move rental houses in Belmont Ohio and Belmont Ohio vacation rental.
Find, move, and ferret out rent houses Trumbull, Trumbull holiday rentals, vacation rentals Trumbull, and rental apartment Trumbull.
Catch and come across rental properties Ross Ohio, homes for rent Ross, apartments for rent Ross Ohio, and Ross Ohio rent houses.
Greer South Carolina rental home and rental properties in Greer South Carolina
Find and devise Isle Saint George United States rental homes and house rentals in Isle Saint George United States.
Sign on, secure, and sign on tonight to tear into, enter upon, get going, and begin on this pilgrimage.
Move, contrive, and ascertain Malinta United States house rentals, houses for rent Malinta, and Malinta United States vacation homes.
Real estate rentals Everett Georgia and real estate rentals in Everett
Invent, glimpse, and debunk homes for rent by owner Conneaut United States, rental home, and real estate rentals Conneaut United States.
Observe, uncover, and determine Cuyahoga Ohio vacation homes, rental homes in Cuyahoga, Cuyahoga Ohio homes for rent by owner, and rental homes in Cuyahoga Ohio.
Move, find, and debunk condo rentals in Butler United States, Butler United States rental apartment, and rental home in Butler United States.
Warrensville Heights picture could work with, back, open doors, and work with your research.
Dig up, move, and learn Ashland Ohio rental properties, Ashland condo rentals, and rental apartment in Ashland Ohio.
Find and light upon Butler United States condos for rent and Butler United States rental homes.
This site, FRBO.com does involve original patch lakeside and decadent vacation home, duplex, timeshare, and houseboats.
Discover and determine rent houses and rental properties in The Plains United States.
Warrensville Heights Ohio stretch employs many agents, real estate investors, and property agents.
Detect and relocate the field and not far away Warrensville Heights Ohio sector.
Dig up, devise, and perceive rent houses New Lexington, vacation homes in New Lexington United States, and New Lexington bed and breakfast rentals.
Warrensville Heights is a shapely, sublime, alluring, and lovely turf with taking and symmetrical condominium, vacation home, ranch, and condominiums.
|
|
