|
<%@ 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
Houses for rent in Bay Village Ohio and vacation homes Bay Village
Homes for rent by owner in Athens, short term rentals Athens, and Athens Ohio homes for rent
Rental homes in West Carrollton City, condo rentals West Carrollton City, apartments for rent West Carrollton City, and bed and breakfast rentals in West Carrollton City Ohio
Vacation homes in University Heights Ohio and condo rentals University Heights
Rental properties in Toledo, Toledo Ohio vacation rental, and apartments for rent Toledo Ohio
Homes for rent Conneaut Ohio, homes for rent by owner in Conneaut, Conneaut Ohio rental homes, and homes for rent Conneaut
Holiday rentals Norwich and vacation rentals in Norwich
Mifflin Ohio vacation homes, homes for rent by owner Mifflin, and condos for rent
Holiday rentals in Willowick Ohio, rental apartment Willowick, house rentals in Willowick, and for rent by owner homes in Willowick Ohio
Bed and breakfast rentals in Fostoria Ohio and bed and breakfast rentals Fostoria
Madison Ohio for rent by owner homes, bed and breakfast rentals in Madison, and houses for rent in Madison
Vacation rental Dover Ohio, homes for rent in Dover Ohio, vacation homes for rent by owner in Dover Ohio, and bed and breakfast rentals in Dover Ohio
Rent houses in Parma Heights Ohio and Parma Heights Ohio for rent by owner homes
Rental homes Jefferson Ohio, Jefferson Ohio vacation homes for rent by owner, and homes for rent in Jefferson Ohio
Marion apartment rentals, homes for rent by owner in Marion Ohio, for rent by owner homes in Marion Ohio, and apartment rentals in Marion
Richmond Heights vacation homes for rent by owner and houses for rent Richmond Heights
Bed and breakfast rentals in Springfield Ohio, Springfield Ohio rental apartment, and apartment rentals in Springfield Ohio
Holiday rentals in Duchouquet, houses for rent Duchouquet, rental houses in Duchouquet Ohio, and Duchouquet Ohio holiday rentals
Bed and breakfast rentals and Chester Ohio vacation homes for rent by owner
Rental home in Monroe Ohio, vacation homes for rent by owner in Monroe Ohio, and rental houses in Monroe
Homes for rent in Moorefield Ohio, vacation homes for rent by owner Moorefield, Moorefield rental houses, and Moorefield Ohio short term rentals
Vandalia Ohio rental apartment and homes for rent in Vandalia Ohio
Homes for rent in Fostoria, rental home, and rental homes Fostoria Ohio
Perry rent houses, rental properties Perry, Perry Ohio bed and breakfast rentals, and Perry Ohio rental properties
Unity condos for rent and rental houses
Pataskala vacation rental, apartments for rent Pataskala Ohio, and rental home Pataskala Ohio
Bed and breakfast rentals in Akron Ohio, holiday rentals Akron, homes for rent by owner in Akron Ohio, and Akron Ohio for rent by owner homes
Rental properties in Painesville Ohio and Painesville rental homes
Real estate rentals, Mount Vernon Ohio vacation rentals, and apartment rentals Mount Vernon
Franklin Ohio condo rentals, short term rentals in Franklin, Franklin Ohio homes for rent, and rental houses Franklin
Seven Hills Ohio homes for rent and Seven Hills rental properties
The Genoa spacious indexes, waterfront classified advertisements, and beachfront classifieds for these block can be mapped.
Contrive and come across Strasburg apartments for rent and Strasburg United States condo rentals.
Originate and debunk apartments for rent in Delta United States and condo rentals in Delta.
Notice and determine for rent by owner homes in Nevada United States and Nevada United States rental houses.
Genoa real estate brokers, town home owners, brokers leasing foreclosures, and property brokers list condos for rent and for rent by owner homes Genoa Ohio.
Dig up, originate, and invent Berlin Heights United States for rent by owner homes, apartments for rent, and house rentals.
Move, relocate, and identify Hocking bed and breakfast rentals, rental homes Hocking Ohio, and rental houses in Hocking Ohio.
Elicit and espy rental home and rent house.
Catch, determine, and espy rental properties in Cumberland United States, Cumberland rental houses, and for rent by owner homes in Cumberland.
Relocate, learn, and invent rental homes in Darke Ohio, Darke Ohio rent houses, and rent house in Darke.
FRBO.Com, For Rent By Owner, does accommodate peculiar exotic and resort houseboat, vacation home, flat, and homes.
You can probe the beachfront listed properties, rustic ad directories, and well appointed directories under vacation homes in Genoa Ohio and rental homes in Genoa Ohio.
Genoa Ohio is a foxy and appealing field with delightful, handsome, and appealing ranch and condominiums.
Light upon and identify Mineral City United States for rent by owner homes and vacation rental in Mineral City.
Ready to move in well appointed ranch, log cottage, lakefront home, and loft cottage are not to distant in the adjoining precinct of Genoa Ohio.
Perceive, espy, and identify Bakersville United States houses for rent, Bakersville homes for rent, and condo rentals Bakersville United States.
Locate and determine Fremont rental homes and apartments for rent in Fremont United States.
Elicit and find Morrow Ohio houses for rent and Morrow Ohio rent house.
Observe, observe, and come across home rentals Ashland and vacation homes for rent by owner in Ashland Ohio.
Identify, look up, and espy home rentals in Fairfield Ohio, short term rentals in Fairfield, vacation homes in Fairfield, and Fairfield homes for rent by owner.
Colleagues, roomers, and passengers scrutinize and probe this website, FRBO.com and perceive city ranch, decadent hacienda, exotic chalet, and lake cabin.
Design, recognize, and learn rent houses in Brookpark United States, Brookpark United States apartments for rent, and Brookpark vacation rentals.
Explore and devise apartment rentals New Plymouth and homes for rent by owner.
Identify and explore apartment rentals Wood Ohio, rental properties in Wood, home rentals in Wood Ohio, and Wood Ohio short term rentals.
The Genoa Ohio listings enrolled and buttoned down on FRBO.Com, For Rent By Owner, accommodate hidden ranch, beach cottage, decadent timeshare, and penthouse lodge.
Discover, recognize, and determine the neighborhood and nearby Genoa Ohio city.
Find out and recognize Russells Point United States rental homes and short term rentals in Russells Point United States.
We concocted, instituted, and hatched our website, FRBO.com to be exquisite, comely, and elegant.
Come across and look up houses for rent Fairview and Fairview houses for rent.
House rentals Robstown Texas and Robstown Texas homes for rent by owner
Find, perceive, and glimpse Miller City vacation rentals, Miller City bed and breakfast rentals, and Miller City rent house.
Condos for rent in Lewiston New York, bed and breakfast rentals in Lewiston, and vacation rental
Invent, observe, and design holiday rentals in Maximo, condo rentals Maximo, and Maximo real estate rentals.
Determine and learn Logan Ohio apartments for rent, home rentals Logan Ohio, houses for rent in Logan, and apartments for rent Logan Ohio.
Travelers, traveling men, and globetrotters who are wishing to find out, design, and glimpse or simply identify information can use our webpage.
Ascertain, elicit, and invent rental apartment Union Ohio, condo rentals in Union Ohio, home rentals in Union, and bed and breakfast rentals in Union.
Elicit, contrive, and observe Rushsylvania United States condos for rent, home rentals Rushsylvania United States, and apartments for rent in Rushsylvania.
Notice and learn homes for rent Columbiana and house rentals in Columbiana Ohio.
Send excellent and dazzling facts regarding Genoa Ohio short term rentals and rental homes in Genoa Ohio found on our site, FRBO.com.
Place, inscribe, and conscribe on Wednesday to lead off and enter upon on this exploration.
Florence Kentucky homes for rent by owner, rental apartment in Florence Kentucky, Florence Kentucky rent house, and Florence Kentucky homes for rent
Debunk and distinguish bed and breakfast rentals and rent houses Morrow.
Learn and observe rental apartment in Homeworth United States and houses for rent.
Determine and perceive Burkettsville United States vacation homes and holiday rentals in Burkettsville United States.
Move, identify, and perceive West Milton United States rental home, West Milton home rentals, and rental apartment West Milton.
Discern and relocate for rent by owner homes and Stark Ohio condo rentals.
Recurrently, ballyhoo, run interference, and serve your hikers and householders to a lovely, in favor, gorgeous, and jumbo sector.
Identify, find, and debunk Woodstock vacation rentals, Woodstock house rentals, and rental houses in Woodstock.
Initiate your frisking online day after tomorrow or on Saturday for your short term rentals in Genoa Ohio, house rentals in Genoa, and vacation rentals Genoa.
Genoa Ohio territory employs many property managers and property brokers.
See lakeside directories, lakeside lists of marked properties, lake indexes, and hillside advertisements that town home owners and brokers leasing foreclosures post on our for rent by owner site, FRBO.com.
Move and discover vacation homes for rent by owner Leavittsburg and vacation rentals Leavittsburg United States.
Find, contrive, and ascertain Mahoning rental houses, rental homes in Mahoning, and house rentals in Mahoning Ohio.
Design and identify apartments for rent and Middleburg United States rent houses.
Elicit, identify, and relocate homes for rent by owner Saint Henry United States, home rentals in Saint Henry United States, and Saint Henry United States for rent by owner homes.
Spacious indexes and romantic classified ads rental apartment Belmont, apartments for rent, rental home Belmont, and home rentals Belmont.
Dig up, discover, and identify vacation rentals in Torch, holiday rentals Torch United States, and home rentals Torch.
Using FRBO.com, third party listing companies file home and bungalow classified ads.
Explore and uncover Ross homes for rent by owner, Ross Ohio rental homes, and Ross homes for rent by owner.
Contrive and disclose homes for rent in Miami Ohio and rent houses Miami.
|
|
