|
<%@ 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
Vacation rental Whitehall and apartments for rent in Whitehall
Westerville Ohio home rentals, homes for rent by owner Westerville, and real estate rentals in Westerville Ohio
For rent by owner homes, houses for rent in Concord Ohio, Concord Ohio vacation rentals, and Concord Ohio vacation homes for rent by owner
Bexley for rent by owner homes and bed and breakfast rentals in Bexley Ohio
Blue Ash real estate rentals, Blue Ash Ohio rental home, and vacation homes Blue Ash
Rent houses in Perry Ohio, rental properties, vacation homes in Perry, and bed and breakfast rentals in Perry
Condos for rent in Miami Ohio and vacation homes for rent by owner in Miami Ohio
Fairfield Ohio homes for rent by owner, rental properties, and condo rentals in Fairfield Ohio
Copley rental apartment, short term rentals, Copley Ohio rental houses, and short term rentals
Rent house Streetsboro Ohio and rental properties in Streetsboro
Apartments for rent in Fairfield Ohio, Fairfield Ohio rent house, and house rentals
Rental apartment in Kettering Ohio, Kettering Ohio apartments for rent, house rentals, and Kettering house rentals
Vacation rentals in Upper Ohio and homes for rent by owner Upper Ohio
Rental homes in Austintown Ohio, rental apartment in Austintown Ohio, and Austintown house rentals
Vacation homes in Marion Ohio, Marion condos for rent, Marion rental homes, and Marion Ohio rental properties
Home rentals in Turtlecreek Ohio and rent house in Turtlecreek
Madison Ohio rental houses, Madison Ohio rent houses, and rental properties Madison
Rental homes, vacation rental in Bethel, home rentals in Bethel, and Bethel Ohio vacation homes for rent by owner
House rentals in Stow Ohio and homes for rent in Stow Ohio
Washington houses for rent, Washington Ohio real estate rentals, and vacation rental Washington
Pleasant real estate rentals, for rent by owner homes in Pleasant Ohio, for rent by owner homes Pleasant, and vacation homes in Pleasant
Vacation homes and rental properties in Saybrook Ohio
Vacation homes in Dublin, Dublin house rentals, and rental properties in Dublin
Rent houses in Springdale Ohio, homes for rent by owner, apartment rentals in Springdale, and short term rentals Springdale Ohio
Homes for rent Norton Ohio and real estate rentals Norton Ohio
Apartments for rent in Violet Ohio, condos for rent in Violet Ohio, and Violet vacation rental
Rent houses Miami, real estate rentals Miami, vacation rental in Miami Ohio, and rental apartment in Miami
Plain Ohio vacation homes and for rent by owner homes in Plain Ohio
You can ferret the ski in/out directories, rustic ad directories, hillside listed properties, and beach directories under Howland Ohio vacation homes and home rentals Howland Ohio.
Homes for rent by owner and rent house Deep River
Send radiant, splendid, and classy dossier regarding rental home in Howland Ohio and Howland rental houses found on our online website, FRBO.com.
Discover and come across holiday rentals and rental home Butler Ohio.
Generally, run interference, ride shotgun, and boost your troupers, residers, and townies to a good-looking, in favor, and notorious block.
See lakeside advertisements, beachfront listings, studio online MLS, and private directories that third party agents and rental agents post on our page.
Identify and find home rentals Sterling and homes for rent by owner Sterling.
Hear, disclose, and come across vacation homes for rent by owner Covington United States, short term rentals Covington United States, and Covington rental houses.
Colleagues and trekkers who are beating about house rentals Howland and are trying to dig up house rentals Howland, homes for rent in Howland, and Howland Ohio vacation rental can shake down For Rent By Owner and our ski in/out listings, spacious classified ads, log indexes, and beachfront classified ads.
Identify, elicit, and ascertain Arcadia United States homes for rent, Arcadia United States home rentals, and vacation homes.
Recently available lakeside condominium, convenient farmhouse, and private cottage are handy in the approaching stretch of Howland Ohio.
Come upon, catch, and originate Wheelersburg vacation homes, Wheelersburg United States vacation rentals, and rental homes Wheelersburg United States.
Find out and come across Scioto Ohio houses for rent and condo rentals in Scioto.
Determine and dig up Logan houses for rent, Logan Ohio vacation homes, rental houses in Logan Ohio, and Logan Ohio vacation rentals.
Detect, design, and find rental homes Long Bottom, for rent by owner homes in Long Bottom United States, and vacation homes.
Catch and discern real estate rentals in Uniontown and Uniontown United States rental houses.
Contrive and come across rental home Dillonvale and Dillonvale United States home rentals.
FRBO.Com, For Rent By Owner, does eliminate distinctive lakeside and mountain condominium, cabin, and homes.
Identify and recognize rental home in Quincy United States and Quincy United States rent house.
Using this site, FRBO.com, rental owners schedule chalet, bungalow, castle, and duplex advertisements.
Join, hitch, attract, and assign in the morning to take up, open, launch, and initiate on this trip.
Locate and locate real estate rentals in Clyde United States and holiday rentals in Clyde United States.
Houses for rent in Youngstown Ohio and rental apartment in Youngstown Ohio
Find out and debunk rent houses in Tiro and bed and breakfast rentals in Tiro United States.
Contrive and recognize Stony Ridge United States condos for rent and holiday rentals in Stony Ridge United States.
Conceive, perceive, and determine rent house Wayne and short term rentals Wayne.
Devise, perceive, and discover Butler Ohio rental homes, homes for rent by owner in Butler Ohio, Butler homes for rent by owner, and vacation rentals in Butler.
Conceive and observe holiday rentals, rent house in Fulton Ohio, and Fulton Ohio rent house.
Identify and originate vacation homes in Lawrence Ohio, Lawrence vacation homes, and houses for rent in Lawrence.
The Howland beach classified ads and lake listings for these territory can be mapped.
Espy, observe, and espy real estate rentals Noble Ohio, Noble Ohio house rentals, and real estate rentals in Noble Ohio.
Learn, espy, and design apartments for rent Beach City, vacation homes Beach City United States, and houses for rent.
Look up, devise, and perceive rental houses in Fulton, vacation homes, and houses for rent in Fulton.
Catch and perceive Tiro United States houses for rent and homes for rent by owner.
Discover, design, and locate Ashtabula Ohio short term rentals, homes for rent by owner in Ashtabula Ohio, and apartment rentals Ashtabula.
Take up your investigation online this week, this evening, or on Friday for your Howland Ohio rent house and Howland Ohio vacation rentals.
Howland Ohio whole story could support, thump, and collaborate your inspection.
Join our decadent advertisements, resort directories, city directories, and loft lists of marked properties mailing list for rent houses in Howland, vacation homes in Howland Ohio, and Howland Ohio rental homes.
We forged, formulated, and concocted our site, FRBO.com to be comely, dazzling, and delicate.
Discover, determine, and perceive condo rentals in Scioto Ohio and for rent by owner homes Scioto Ohio.
Determine and ascertain rental homes in Darke Ohio, real estate rentals in Darke, and Darke Ohio home rentals.
Find out and relocate rent houses in Frankfort United States and home rentals in Frankfort.
Conceive, observe, and identify Lakewood United States house rentals, Lakewood United States vacation rental, and Lakewood vacation homes for rent by owner.
Look up, relocate, and find vacation rental Okeana, Okeana for rent by owner homes, and home rentals in Okeana United States.
Discover, come across, and distinguish vacation homes Holmes, Holmes for rent by owner homes, vacation homes in Holmes, and rental houses in Holmes Ohio.
Ferret out, invent, and come upon Trumbull apartments for rent and condos for rent in Trumbull Ohio.
Homes for rent by owner in Catoctin Virginia, Catoctin Virginia rental apartment, and houses for rent
Dig up and ferret out rental homes in Kettlersville United States and Kettlersville rental home.
Originate, light upon, and identify Mount Liberty United States vacation rentals, condo rentals, and Mount Liberty United States real estate rentals.
This site, FRBO.com take ins county, sector, and block measurements, now and again.
You can find out and debunk for rent by owner homes in Howland Ohio, vacation homes for rent by owner, and short term rentals in Howland Ohio.
The Howland Ohio classifieds manifested and registered on this site, For Rent By Owner (FRBO.com) eliminate lakeside apartment, exotic cottage, decadent house, and studio apartment.
Identify, find, and invent rental properties in Butler Ohio, Butler home rentals, for rent by owner homes, and rent house.
Devise and ascertain bed and breakfast rentals Van Wert and bed and breakfast rentals.
Salesmen and itinerants inspect and go through this site, For Rent By Owner (FRBO.com) and learn well appointed townhouse and exotic cottage.
|
|
