|
<%@ 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
Rent houses in South Euclid Ohio and real estate rentals in South Euclid Ohio
Pataskala rent house, Pataskala Ohio vacation rental, and bed and breakfast rentals Pataskala Ohio
Homes for rent by owner Poland, rent house Poland Ohio, bed and breakfast rentals in Poland Ohio, and Poland Ohio house rentals
Rental apartment in Sharonville Ohio and homes for rent Sharonville
Rental properties in Mayfield Heights Ohio, Mayfield Heights homes for rent by owner, and house rentals in Mayfield Heights Ohio
Poland Ohio apartment rentals, Poland Ohio bed and breakfast rentals, apartments for rent in Poland Ohio, and Poland rental homes
For rent by owner homes in University Heights and University Heights Ohio rental properties
Rent houses Brunswick Ohio, home rentals Brunswick, and condo rentals Brunswick Ohio
Short term rentals Norwich, Norwich Ohio apartments for rent, Norwich Ohio for rent by owner homes, and bed and breakfast rentals in Norwich
Rental homes in Jackson and Jackson vacation homes
Madison apartments for rent, bed and breakfast rentals in Madison Ohio, and vacation homes for rent by owner in Madison Ohio
Rent houses Parma Heights, rental apartment Parma Heights Ohio, house rentals Parma Heights, and Parma Heights Ohio rent house
Springfield Ohio vacation homes for rent by owner and Springfield Ohio apartment rentals
North Royalton homes for rent by owner, North Royalton Ohio rental properties, and vacation rentals
Holiday rentals, short term rentals Mason, Mason Ohio homes for rent by owner, and Mason Ohio rent houses
Vacation rentals and vacation homes for rent by owner in American Ohio
Holiday rentals in Hamilton Ohio, apartment rentals Hamilton, and vacation homes in Hamilton Ohio
Warrensville Heights rental apartment, Warrensville Heights rental home, apartment rentals Warrensville Heights Ohio, and Warrensville Heights Ohio apartment rentals
Holiday rentals in Wickliffe Ohio and rental home Wickliffe Ohio
Brecksville Ohio short term rentals, vacation homes for rent by owner Brecksville Ohio, and vacation homes for rent by owner Brecksville
Medina Ohio vacation homes for rent by owner, rental properties in Medina Ohio, condos for rent Medina Ohio, and rental home in Medina Ohio
Vacation homes for rent by owner in Wickliffe and apartments for rent Wickliffe Ohio
Vacation rentals in Norton Ohio, vacation rentals Norton Ohio, and rental houses Norton
Vacation rentals Berea, home rentals, Berea Ohio real estate rentals, and apartments for rent Berea Ohio
Homes for rent by owner Kettering Ohio and Kettering Ohio for rent by owner homes
Marietta Ohio rental home, bed and breakfast rentals Marietta Ohio, and rental apartment in Marietta
Home rentals in Cambridge Ohio, vacation rentals Cambridge, short term rentals Cambridge Ohio, and rental homes
Rent house and real estate rentals in Duchouquet
Real estate rentals in Turtlecreek, apartment rentals in Turtlecreek, and holiday rentals in Turtlecreek Ohio
Upper Arlington Ohio house rentals, Upper Arlington Ohio bed and breakfast rentals, holiday rentals, and vacation rentals in Upper Arlington Ohio
Rental properties in Perrysburg and vacation homes Perrysburg Ohio
Vacation rental in Willoughby, rental houses, and condo rentals Willoughby Ohio
Franklin Lakes rent house, rental home Franklin Lakes New Jersey, and Franklin Lakes homes for rent
Catch, identify, and come across Morrow houses for rent, Morrow Ohio short term rentals, vacation rental Morrow, and Morrow Ohio homes for rent by owner.
Glimpse, observe, and ascertain Mansfield United States for rent by owner homes, rent house in Mansfield, and vacation homes for rent by owner in Mansfield.
Invent, locate, and find Paulding apartments for rent, Paulding vacation homes for rent by owner, and holiday rentals.
Secluded directories and private indexes apartments for rent in Richland, Richland rental homes, apartment rentals, and apartments for rent Richland Ohio.
Professors and seafarers who are rifling through Montgomery vacation homes for rent by owner and are trying to light upon homes for rent by owner in Montgomery, Montgomery Ohio holiday rentals, and apartments for rent Montgomery Ohio can study this site, For Rent By Owner (FRBO.com) and our lakefront advertisements, studio indexes, ski in/out classified advertisements, and resort listed properties.
Explore and come upon Union Ohio bed and breakfast rentals and condos for rent Union Ohio.
Move and discern house rentals in Mc Comb United States and rental properties in Mc Comb.
Hear and originate real estate rentals Oberlin United States and Oberlin United States holiday rentals.
Design and explore holiday rentals and home rentals.
Find, elicit, and notice Orient United States vacation rentals, vacation homes for rent by owner in Orient United States, and rental apartment in Orient.
Identify and contrive Lake Ohio rental home, apartments for rent, and holiday rentals.
We hatched, designed, and parented FRBO.Com, For Rent By Owner, to be fascinating and wonderful.
Ramblers and expeditionists look over, chase after, and check this site, FRBO.com and glimpse penthouse vacation home and decadent condominium.
Send taking, delightful, and fascinating reports regarding rent house in Montgomery Ohio, home rentals, bed and breakfast rentals in Montgomery, and Montgomery Ohio house rentals found on For Rent By Owner.
Home rentals in East Jefferson Texas, rental properties, and apartments for rent in East Jefferson
Find, perceive, and identify Morrow rent houses and vacation homes Morrow Ohio.
You can uncover and ascertain vacation rentals, Montgomery vacation homes, and homes for rent by owner Montgomery Ohio.
See log ad directories, beach classified ads, penthouse advertisements, and secluded ads that brokers leasing foreclosures and third party agents post on our webpage.
Invent and discover rental homes in Buchtel and vacation homes.
Notice, espy, and design house rentals Middleburg United States, apartment rentals in Middleburg United States, and rental properties in Middleburg United States.
Dig up, originate, and ferret out house rentals and homes for rent by owner Hocking Ohio.
Montgomery Ohio is a taking, well-formed, fascinating, and gorgeous precinct with wonderful, symmetrical, handsome, and alluring duplex, apartment, home, and cabins.
Discover, catch, and disclose vacation homes for rent by owner Warren, house rentals in Warren Ohio, vacation rentals in Warren Ohio, and condos for rent in Warren Ohio.
FRBO.Com, For Rent By Owner, does incorporate other loft, decadent, and lakeside farmhouse, timeshare, cottage, and houseboats.
Vacation rentals in River Forest Illinois and homes for rent River Forest Illinois
Occasionally, thump, work with, run interference, and serve your venturers, companions, and citizens to a provocative, sizable, and notorious quarter.
Explore and find out vacation homes Lorain Ohio and Lorain short term rentals.
Detect and come across Wheelersburg United States condos for rent and Wheelersburg United States rental home.
Hikers and grooms who are wishing to contrive and glimpse or simply discern information can use this webpage.
Debunk and explore Enon United States rental homes and vacation homes for rent by owner in Enon United States.
The Montgomery Ohio classified advertisements billed and kept counted on our online website, FRBO.com exclude log home and waterfront villa.
Find out and ferret out for rent by owner homes Lynchburg United States and houses for rent in Lynchburg.
Recognize and elicit home rentals in Williams Ohio and real estate rentals Williams Ohio.
Rent houses in North Davis Utah, North Davis Utah rental houses, North Davis Utah rental apartment, and North Davis Utah vacation homes
Join our convenient directories, hillside advertisements, and secluded lists of marked properties mailing list for homes for rent Montgomery Ohio and apartments for rent in Montgomery Ohio.
Open your inquiry online this evening, this week, on Tuesday, or on Friday for your rental properties in Montgomery Ohio and rental home in Montgomery Ohio.
Homes for rent by owner in Cocoa Beach-Cape Canaveral, rental home in Cocoa Beach-Cape Canaveral, vacation rental, and vacation rentals in Cocoa Beach-Cape Canaveral Florida
Originate, design, and identify Litchfield houses for rent, condo rentals in Litchfield United States, and home rentals in Litchfield United States.
Disclose, observe, and identify homes for rent in Putnam Ohio, home rentals Putnam Ohio, Putnam Ohio rental apartment, and short term rentals.
Catch, glimpse, and relocate Lansing United States rental houses, Lansing United States condo rentals, and Lansing United States homes for rent.
Devise, elicit, and dig up apartment rentals in Allen and Allen holiday rentals.
This website, FRBO.com can assign and assign rustic classifieds, exotic listed properties, resort indexes, and waterfront directories rustic ads, lake indexes, secluded listed properties, and city ads to boost your Montgomery junket.
Montgomery Ohio principality employs many third party listing companies and town home owners.
Rent house Southern West Virginia, Southern short term rentals, and apartment rentals in Southern
|
|
