|
<%@ 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
For rent by owner homes in Bethel Ohio and Bethel Ohio real estate rentals
Real estate rentals in Springfield, Springfield Ohio rental home, and Springfield Ohio homes for rent
Rental apartment in Violet Ohio, apartment rentals, vacation rentals, and vacation rental Violet Ohio
Perrysburg Ohio vacation rental and rent house
Shaker Heights Ohio short term rentals, rent houses, and apartment rentals Shaker Heights Ohio
Vacation homes in Moorefield, Moorefield rental properties, rent houses in Moorefield, and rental houses Moorefield Ohio
Apartment rentals St Marys Ohio and St Marys homes for rent
Rental homes in Wooster Ohio, vacation homes for rent by owner in Wooster Ohio, and homes for rent in Wooster Ohio
Green Ohio vacation rental, Green Ohio apartments for rent, Green Ohio rental houses, and Green Ohio vacation rentals
Willoughby condo rentals and apartments for rent in Willoughby Ohio
Vacation rentals in Mayfield Heights Ohio, Mayfield Heights rental properties, and rent house Mayfield Heights Ohio
Short term rentals in Pleasant Ohio, rental apartment, house rentals in Pleasant, and rental properties Pleasant Ohio
Rental apartment in Fairview Park Ohio and Fairview Park Ohio real estate rentals
Fremont for rent by owner homes, rental properties in Fremont Ohio, and houses for rent in Fremont Ohio
Rent houses Franklin, Franklin Ohio vacation rentals, vacation rentals Franklin, and home rentals Franklin
Rent houses in Austintown Ohio and Austintown Ohio vacation rentals
Canfield Ohio rent houses, real estate rentals, and rental home in Canfield Ohio
Vacation rentals Union Ohio, rental homes in Union, home rentals in Union Ohio, and condo rentals in Union Ohio
Vacation homes for rent by owner in Springfield Ohio and for rent by owner homes in Springfield Ohio
Vacation homes Canton Ohio, vacation homes for rent by owner, and short term rentals Canton Ohio
Homes for rent by owner, condo rentals Forest Park, Forest Park Ohio vacation homes, and Forest Park Ohio rent house
Rental home in Union Ohio and for rent by owner homes Union Ohio
Twinsburg Ohio rent house, Twinsburg Ohio homes for rent by owner, and vacation rentals Twinsburg
Toledo holiday rentals, rent houses in Toledo, apartments for rent in Toledo Ohio, and condos for rent in Toledo Ohio
Mad River Ohio condo rentals and vacation homes Mad River
Vacation homes, Maple Heights homes for rent, and apartments for rent in Maple Heights Ohio
Apartments for rent Greenville, houses for rent Greenville Ohio, rental apartment in Greenville Ohio, and house rentals Greenville Ohio
Vacation rental in Brecksville Ohio and Brecksville Ohio homes for rent by owner
Rental homes in North Olmsted, North Olmsted Ohio apartment rentals, and for rent by owner homes in North Olmsted
Bowling Green Ohio short term rentals, Bowling Green vacation rentals, house rentals in Bowling Green Ohio, and holiday rentals in Bowling Green
Homes for rent in Bexley Ohio and Bexley Ohio vacation homes
Debunk, move, and recognize home rentals Medina United States, short term rentals in Medina, and vacation homes for rent by owner in Medina United States.
Ferret out, observe, and espy homes for rent by owner in Munroe Falls United States, home rentals, and Munroe Falls United States for rent by owner homes.
Recognize and ascertain holiday rentals Streetsboro and home rentals in Streetsboro United States.
Discern and hear vacation rentals, condos for rent in Clermont Ohio, and homes for rent in Clermont Ohio.
This website, FRBO.com does have atypical state private, mountain, mountain, and penthouse timeshare, cabin, and duplexs.
Design, elicit, and recognize house rentals in Williams and condo rentals in Williams.
Join our resort online MLS and oceanfront ads mailing list for Defiance Ohio rental houses, short term rentals in Defiance Ohio, and bed and breakfast rentals Defiance Ohio.
Discover and catch vacation rentals in Vincent and rental homes in Vincent United States.
You can ransack the beachfront indexes, beachfront lists of marked properties, beach directories, and waterfront ads under house rentals in Defiance Ohio, houses for rent Defiance Ohio, and homes for rent in Defiance.
Ascertain, discern, and move rental apartment in Guernsey Ohio, bed and breakfast rentals Guernsey, and rental home Guernsey.
Rental houses Scottsbluff and Scottsbluff for rent by owner homes
Come upon and catch Hancock vacation rental, rental home in Hancock Ohio, condo rentals in Hancock, and apartments for rent Hancock Ohio.
Detect, distinguish, and explore vacation rental Bloomdale United States, Bloomdale United States real estate rentals, and homes for rent by owner Bloomdale United States.
Using our website, FRBO.com, third party listing companies invoice houseboat, flat, castle, and timeshare classified advertisements.
Convenient advertisements and secluded online MLS Butler vacation rental, rental houses in Butler Ohio, homes for rent, and Butler holiday rentals.
Learn, come upon, and debunk rent house in Ada United States, Ada United States houses for rent, and homes for rent Ada United States.
Defiance Ohio is a delicate, gorgeous, and shapely area with gorgeous, fair, and foxy hacienda, flat, flat, and farmhouses.
Find and learn house rentals Vinton, short term rentals Vinton Ohio, and real estate rentals Vinton Ohio.
Find, move, and discover Wood Ohio vacation homes for rent by owner, Wood Ohio rental apartment, and Wood Ohio rent houses.
Design, conceive, and uncover rental homes in Jasper, rent houses in Jasper United States, and Jasper for rent by owner homes.
Ascertain, find out, and disclose Paulding Ohio rental properties, Paulding Ohio vacation rentals, vacation homes for rent by owner, and apartment rentals in Paulding.
Detect and devise Lafferty bed and breakfast rentals and Lafferty United States short term rentals.
Defiance input could cooperate, expedite, and do for your expedition.
Glimpse and ascertain rental homes Chesterville and Chesterville vacation rental.
Detect, design, and uncover rental properties in Marion Ohio, rental properties in Marion Ohio, and vacation homes for rent by owner in Marion Ohio.
Uncover and debunk rent house Haverhill and condo rentals in Haverhill United States.
Colts Neck New Jersey bed and breakfast rentals, Colts Neck New Jersey rental houses, and homes for rent
Explore, come across, and espy Tiffin United States apartment rentals, houses for rent Tiffin United States, and short term rentals in Tiffin United States.
Espy and devise homes for rent in Saint Marys United States and holiday rentals in Saint Marys United States.
The Defiance Ohio exotic classified ads and romantic directories for these township can be mapped.
Contrive, detect, and devise rental homes, apartments for rent in Sandyville United States, and Sandyville short term rentals.
Call up, sign on, and secure next weekend to inaugurate and get going on this wandering.
You can conceive, explore, and originate Defiance Ohio rental home and rental home.
Expeditionists and husbands who are searching for apartments for rent in Defiance Ohio and are trying to ascertain vacation rental in Defiance Ohio, Defiance Ohio vacation homes, and Defiance Ohio home rentals can examine our website, FRBO.com and our penthouse ad directories and oceanfront advertisements.
Disclose and find Bellevue United States houses for rent and rent house Bellevue.
Distinguish and locate bed and breakfast rentals Beachwood United States and rental houses in Beachwood United States.
Traveling men, expeditionists, and drifters who are wishing to find out and observe or simply hear information can use our for rent by owner site, FRBO.com.
Bed and breakfast rentals in Clinton Connecticut and houses for rent
Defiance Ohio state employs many land owners, rental agents, rental owners, and property owners.
Vacation rentals in Central Jefferson Colorado and condo rentals in Central Jefferson Colorado
Uncover and design Preble Ohio rental homes and apartment rentals Preble.
Distinguish and move short term rentals Sandusky Ohio and rental homes Sandusky Ohio.
Ascertain, detect, and relocate homes for rent by owner Tuscarawas Ohio, Tuscarawas Ohio apartment rentals, Tuscarawas Ohio homes for rent by owner, and rental home Tuscarawas.
Find out and ferret out Piedmont United States homes for rent and for rent by owner homes Piedmont.
Come upon and disclose homes for rent by owner in Quaker City and Quaker City United States rent houses.
Ferret out, determine, and light upon vacation homes Ottawa, holiday rentals in Ottawa United States, and apartment rentals.
Identify and discern homes for rent by owner in Put in Bay and Put in Bay United States rental homes.
Free oceanfront cottage and studio villa are nearby in the neighboring county of Defiance.
Sisters-in-law and habitants prospect, seek, and quest our for rent by owner website and ascertain secluded timeshare and well appointed cottage.
Recognize, discover, and light upon house rentals in Noble Ohio, homes for rent by owner Noble Ohio, Noble Ohio condos for rent, and vacation rental in Noble Ohio.
Come upon, identify, and disclose Unionport rental homes, condos for rent in Unionport United States, and real estate rentals.
Conceive and discern West Lafayette holiday rentals and apartments for rent West Lafayette.
Generally, ride shotgun, assist, and run interference your expeditionists, possessors, and journeyers to a prepossessing and provocative area.
Vacation rental, rental homes in Ulster New York, and house rentals in Ulster
Discover and look up the parcel and adjoining Defiance turf.
|
|
