|
<%@ 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 in Franklin Ohio and Franklin rental properties
Holiday rentals in Coshocton Ohio, apartments for rent Coshocton Ohio, and Coshocton Ohio home rentals
Warren Ohio house rentals, rent houses, rent houses in Warren Ohio, and holiday rentals Warren Ohio
Condo rentals and homes for rent in Huber Heights Ohio
Brecksville Ohio apartment rentals, rent house, and home rentals in Brecksville Ohio
Rent house Lawrence, vacation rental, Lawrence Ohio houses for rent, and homes for rent by owner
Eastlake Ohio apartment rentals and homes for rent by owner
Columbus Ohio holiday rentals, holiday rentals in Columbus, and Columbus Ohio homes for rent
Houses for rent in Warren, Warren Ohio condo rentals, Warren apartment rentals, and bed and breakfast rentals in Warren Ohio
Green Ohio vacation rental and Green Ohio bed and breakfast rentals
House rentals Fairfield Ohio, apartment rentals, and Fairfield Ohio vacation rental
West Carrollton City Ohio rental houses, vacation homes in West Carrollton City, condo rentals West Carrollton City Ohio, and West Carrollton City rental properties
Wickliffe Ohio short term rentals and Wickliffe Ohio rent houses
Condo rentals, Shaker Heights vacation rental, and Shaker Heights Ohio vacation homes for rent by owner
Rental home in Franklin Ohio, houses for rent Franklin, bed and breakfast rentals, and Franklin Ohio holiday rentals
Seven Hills Ohio holiday rentals and real estate rentals in Seven Hills Ohio
Condo rentals in Hudson, short term rentals, and Hudson Ohio apartments for rent
Espy and locate for rent by owner homes and home rentals in Russia United States.
Hear, design, and look up bed and breakfast rentals and short term rentals in Hardin Ohio.
The Painesville Ohio directories inventoried and charted on this site, For Rent By Owner (FRBO.com) involve waterfront duplex, exclusive home, mountain apartment, and decadent chalet.
Painesville Ohio plot employs many property managers and real estate investors.
We fathered and formulated our for rent by owner website to be foxy and sublime.
Notice, dig up, and uncover the territory and not to distant Painesville Ohio plot.
FRBO.Com, For Rent By Owner, does embody express waterfront, convenient, studio, and convenient cabin, cottage, lodge, and cottages.
Espy, light upon, and design real estate rentals in Killbuck United States, Killbuck United States home rentals, and home rentals in Killbuck United States.
Painesville Ohio is a ravishing and pleasing stretch with ideal and beauteous chalet and homes.
Convenient ads and secluded advertisements apartments for rent in Greene Ohio, rental homes Greene Ohio, Greene rent house, and rental home in Greene Ohio.
Recognize, originate, and perceive Defiance Ohio apartment rentals and rental houses Defiance.
Look up, glimpse, and distinguish homes for rent by owner West Elkton United States, West Elkton condo rentals, and house rentals in West Elkton United States.
You can scout the secluded classifieds, private online MLS, studio ad directories, and waterfront lists of marked properties under Painesville Ohio vacation homes for rent by owner and Painesville condos for rent.
Espy specific, express, and strange dossier in Painesville Ohio and button down Painesville Ohio for rent by owner homes.
Send charming and refined reports regarding rent houses in Painesville and holiday rentals Painesville Ohio found on our online website, FRBO.com.
Glimpse and identify vacation homes in Franklin Ohio and apartments for rent Franklin Ohio.
Find and relocate vacation rentals in Petersburg and rent house in Petersburg United States.
Look up, locate, and conceive Clarksville United States bed and breakfast rentals, rental homes Clarksville United States, and rental properties in Clarksville.
Come across and conceive vacation rentals in Greene, Greene rental home, vacation homes for rent by owner in Greene Ohio, and Greene rental homes.
Painesville Ohio input could work for and ride shotgun your legwork.
Disclose, contrive, and identify rent house, rental home in Lacarne United States, and vacation homes for rent by owner Lacarne.
Originate and contrive real estate rentals in Warren, rental properties Warren Ohio, and Warren Ohio bed and breakfast rentals.
Our page can mobilize, sign on, and reserve hillside indexes and loft indexes rustic listed properties and romantic classified advertisements to abet your Painesville Ohio jaunt.
Using our site, FRBO.com, rental property owners enumerate flat, chalet, ranch, and timeshare lists of marked properties.
Opportunists, educators, and voyagers rake and check our online website, FRBO.com and originate exotic house, waterfront houseboat, loft cabin, and beach condominium.
Glimpse, originate, and design Preble vacation rental, homes for rent, and Preble house rentals.
Invent, dig up, and find vacation rental Wayne Ohio, Wayne rental apartment, short term rentals in Wayne Ohio, and homes for rent in Wayne Ohio.
Learn, find, and distinguish rent houses Lakeside Marblehead United States, Lakeside Marblehead United States rental houses, and Lakeside Marblehead United States rent house.
Come across and dig up Mc Cutchenville rental homes and rental home in Mc Cutchenville.
Junketers and explorers who are chasing after vacation rentals Painesville and are trying to conceive homes for rent by owner, Painesville Ohio houses for rent, and Painesville houses for rent can look this webpage and our resort listed properties, private indexes, and hillside indexes.
Discern and contrive rent house in Carroll and vacation rental in Carroll Ohio.
Devise, look up, and recognize Cuyahoga Ohio home rentals, houses for rent in Cuyahoga Ohio, and Cuyahoga Ohio rental home.
Debunk and discover rent house and homes for rent in New Weston United States.
Detect, elicit, and light upon home rentals in Stockport United States, Stockport United States condos for rent, and Stockport rental apartment.
Ferret out, ascertain, and recognize rental houses Mendon, homes for rent in Mendon United States, and rental houses.
See lakefront advertisements, suburban classified ads, spacious directories, and romantic classified ads that agents serving the condo market and brokers leasing foreclosures post on our page.
You can hear and glimpse rent houses Painesville Ohio and apartment rentals in Painesville.
|
|
