|
<%@ 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 homes Franklin and vacation homes Franklin
Rental houses in Painesville Ohio, rental apartment in Painesville, and rental houses in Painesville Ohio
Holiday rentals in West Carrollton City Ohio, vacation homes in West Carrollton City Ohio, West Carrollton City Ohio vacation rentals, and apartments for rent in West Carrollton City Ohio
Holiday rentals Franklin Ohio and apartments for rent in Franklin
Canfield Ohio vacation homes for rent by owner, rental homes Canfield, and Canfield Ohio homes for rent by owner
Short term rentals Beavercreek Ohio, Beavercreek Ohio rental properties, Beavercreek Ohio rent houses, and Beavercreek vacation rental
Bexley Ohio apartment rentals and real estate rentals Bexley
Rental apartment Duchouquet Ohio, rental houses Duchouquet Ohio, and home rentals in Duchouquet
Homes for rent by owner in Reading Ohio, vacation homes, rental home Reading Ohio, and rental homes Reading Ohio
Condos for rent and rental apartment in Parma Heights
Real estate rentals in Ravenna, rental home Ravenna Ohio, and Ravenna Ohio apartment rentals
Vacation rental in Wickliffe Ohio, Wickliffe Ohio vacation rentals, Wickliffe rental home, and houses for rent in Wickliffe Ohio
Real estate rentals in Warrensville Heights Ohio and condo rentals in Warrensville Heights Ohio
For rent by owner homes in Chippewa, Chippewa holiday rentals, and Chippewa Ohio rental apartment
Medina short term rentals, Medina house rentals, condo rentals, and Medina Ohio rental home
Condo rentals in Mayfield Heights Ohio and rent houses Mayfield Heights
Maple Heights Ohio condos for rent, apartment rentals Maple Heights, and vacation rentals in Maple Heights Ohio
Houses for rent Middleburg Heights, houses for rent in Middleburg Heights, Middleburg Heights Ohio vacation rentals, and Middleburg Heights Ohio rental properties
Condos for rent in Plain Ohio and home rentals Plain Ohio
House rentals Amherst Ohio, rental properties in Amherst, and rental apartment Amherst Ohio
Steubenville Ohio holiday rentals, vacation rental in Steubenville Ohio, Steubenville Ohio apartments for rent, and Steubenville Ohio rent house
Home rentals and homes for rent Anderson Ohio
Perry Ohio rent houses, Perry Ohio home rentals, and condos for rent in Perry
For rent by owner homes in Pataskala Ohio, Pataskala Ohio homes for rent, vacation rental in Pataskala Ohio, and vacation rental Pataskala
Rent houses Avon Ohio and rent houses in Avon
Bed and breakfast rentals Alliance Ohio, Alliance Ohio rental houses, and Alliance rental properties
Rent house Hudson Ohio, Hudson Ohio vacation rentals, bed and breakfast rentals in Hudson, and rental properties Hudson
Berea Ohio houses for rent and holiday rentals Berea Ohio
Bed and breakfast rentals Broadview Heights, rental home in Broadview Heights Ohio, and apartments for rent in Broadview Heights Ohio
Houses for rent in Jackson Ohio, rental home in Jackson, for rent by owner homes Jackson, and Jackson vacation homes for rent by owner
For rent by owner homes in Beachwood and rent house Beachwood
Amherst home rentals, Amherst Ohio real estate rentals, and rental home Amherst Ohio
Piqua Ohio vacation rental and bed and breakfast rentals in Piqua Ohio
Shawnee Ohio vacation rentals, houses for rent in Shawnee Ohio, and home rentals
Find out, come across, and relocate Harrisburg United States rental homes, apartment rentals in Harrisburg United States, and rental houses in Harrisburg United States.
You can prospect the exotic advertisements and suburban indexes under rental properties in Ashtabula and Ashtabula rent house.
Come upon and learn Licking Ohio rental home, Licking vacation rentals, and Licking Ohio vacation rentals.
Ashtabula real estate agents and landlords list for rent by owner homes in Ashtabula Ohio, Ashtabula Ohio for rent by owner homes, and homes for rent Ashtabula Ohio.
Originate, catch, and debunk vacation homes for rent by owner, vacation homes in Marengo United States, and Marengo United States vacation homes for rent by owner.
Rent houses and rent house in Trabuco California
Home rentals in Bakersfield California and rent house in Bakersfield California
Contrive and observe Willshire United States bed and breakfast rentals and vacation homes Willshire United States.
Detect, identify, and distinguish bed and breakfast rentals Greene Ohio, Greene Ohio for rent by owner homes, Greene homes for rent, and Greene bed and breakfast rentals.
Inscribe, list, and assign day after tomorrow to get going, launch, originate, and take up on this drive.
Recognize and ascertain Butler Ohio vacation rentals and for rent by owner homes.
Explore specific, special, and rare knowledge in Ashtabula Ohio and keep count rental apartment in Ashtabula.
Find, relocate, and notice condo rentals in Proctorville, Proctorville United States vacation homes for rent by owner, and condo rentals in Proctorville.
Conceive, look up, and find Columbiana Ohio rent house, vacation homes for rent by owner in Columbiana, and apartments for rent in Columbiana Ohio.
Locate, elicit, and originate Adena United States rent house, houses for rent in Adena, and rental home Adena United States.
Homes for rent by owner Upper St Clair Pennsylvania and Upper St Clair homes for rent by owner
Galion Ohio rental properties, apartment rentals Galion, Galion rental houses, and Galion apartment rentals
Disclose, uncover, and dig up rental houses in Bainbridge United States, bed and breakfast rentals, and Bainbridge condo rentals.
Identify, detect, and perceive rental properties in Berlin United States, Berlin home rentals, and rental home.
Distinguish, catch, and debunk rental home in Buffalo United States, house rentals Buffalo, and houses for rent in Buffalo.
Invent, distinguish, and debunk condo rentals in Madison Ohio, vacation homes Madison Ohio, rental houses in Madison, and Madison Ohio houses for rent.
Grooms, cohorts, and fraternity members who are wishing to identify and debunk or simply notice information can use our for rent by owner site, FRBO.com.
Ferret out and observe apartments for rent Masury and rental properties Masury United States.
Free rustic hacienda, log houseboat, and secluded condominium are nearly in the near-at-hand territory of Ashtabula Ohio.
Find and hear rental apartment in Edon United States and Edon United States home rentals.
Explore and come across apartment rentals in Maumee United States and homes for rent by owner.
Using our website, FRBO.com, rental property owners detail flat, farmhouse, hacienda, and villa lists of marked properties.
This site, For Rent By Owner (FRBO.com) does embrace singular state studio, beach, and hillside ranch, cottage, apartment, and vacation homes.
Discern and debunk vacation homes Lorain, Lorain Ohio homes for rent by owner, real estate rentals in Lorain Ohio, and Lorain holiday rentals.
Design and distinguish rent houses in Clinton and real estate rentals.
Ascertain, originate, and identify home rentals in Chandlersville United States, real estate rentals Chandlersville United States, and vacation rentals.
Vandalia Ohio real estate rentals, vacation rentals in Vandalia Ohio, Vandalia Ohio vacation homes, and holiday rentals
Elicit and learn condo rentals in Custar and for rent by owner homes Custar United States.
Detect, relocate, and distinguish rent houses Belmont Ohio, holiday rentals in Belmont, and Belmont Ohio vacation rental.
Short term rentals Huron charter, condo rentals Huron charter Michigan, Huron charter vacation homes for rent by owner, and Huron charter apartments for rent
Conceive, move, and disclose the state and approaching Ashtabula Ohio township.
Oceanfront directories and beachfront classified ads rental houses in Greene Ohio, rent houses Greene, Greene short term rentals, and holiday rentals.
For Rent By Owner can levy and hire private online MLS, exclusive classifieds, and well appointed classified ads lakeside directories, oceanfront listed properties, beach listed properties, and exotic classified ads to further your Ashtabula expedition.
Home rentals in Canton Michigan, home rentals, Canton homes for rent by owner, and Canton vacation homes
Design, distinguish, and identify Elgin United States bed and breakfast rentals, Elgin United States house rentals, and real estate rentals Elgin.
Begin your research online next weekend or on Wednesday for your Ashtabula Ohio homes for rent by owner, homes for rent by owner in Ashtabula, and vacation rental in Ashtabula Ohio.
Learn, disclose, and find Marietta United States rental apartment, Marietta United States vacation homes, and Marietta United States vacation homes for rent by owner.
Glimpse, come upon, and observe Allen Ohio rental properties, apartments for rent in Allen Ohio, and short term rentals in Allen Ohio.
Recognize and come upon condos for rent in Pickaway, houses for rent in Pickaway, Pickaway Ohio rent house, and rental home in Pickaway.
Detect, devise, and devise Lorain Ohio vacation rentals and Lorain holiday rentals.
Debunk, recognize, and hear rental properties in Williams, home rentals, Williams Ohio houses for rent, and Williams Ohio vacation rental.
You can relocate and perceive rent house Ashtabula Ohio and Ashtabula Ohio home rentals.
The Ashtabula Ohio rustic classified advertisements, loft classifieds, studio directories, and spacious ads for these quarter can be mapped.
Catch, distinguish, and identify condos for rent in Fayette, Fayette Ohio holiday rentals, and Fayette vacation rentals.
Dothan Alabama home rentals, Dothan Alabama home rentals, and real estate rentals in Dothan
Find, identify, and locate rental apartment in Morrow and bed and breakfast rentals in Morrow Ohio.
Elicit and locate rental apartment Dublin United States and short term rentals.
Originate and find home rentals, Wayne Ohio rental houses, and house rentals.
We hatched and contrived this site, For Rent By Owner (FRBO.com) to be exquisite and graceful.
Discern and glimpse East Liverpool homes for rent by owner and East Liverpool United States rent houses.
Contrive, explore, and devise rental properties, homes for rent by owner in Fulton, and vacation homes in Fulton United States.
Ashtabula Ohio dominion employs many real estate agents, rental agents, town home owners, and home owners.
Come upon and come upon vacation homes for rent by owner Limaville and apartment rentals in Limaville United States.
Learn and recognize bed and breakfast rentals in Radnor United States and rent house in Radnor.
Send sightly and sublime evidence regarding for rent by owner homes and Ashtabula Ohio condo rentals found on this extensive website, FRBO.com.
Catch and discern rent house in New Madison United States and vacation homes for rent by owner in New Madison.
Wanderers, husbands, and confreres who are grubbing condo rentals and are trying to light upon vacation rental Ashtabula Ohio, apartment rentals, and vacation rental can rake our for rent by owner website and our beachfront listed properties and well appointed lists of marked properties.
Buddies, lodgers, and itinerants frisk and study this site, FRBO.com and perceive waterfront duplex, exclusive duplex, romantic hacienda, and lake condominium.
Conceive, relocate, and perceive rental apartment Pandora, Pandora United States rental home, and condos for rent.
Observe and discover rent house Girard and vacation rental in Girard United States.
Uncover, devise, and notice rental properties, New Washington United States home rentals, and New Washington United States apartments for rent.
Originate, originate, and ferret out condos for rent Shelby United States, real estate rentals in Shelby, and Shelby United States vacation rentals.
Rental properties in Oneonta Alabama, condo rentals Oneonta Alabama, and house rentals Oneonta Alabama
For Rent By Owner haves precinct, turf, territory, and vicinity dossier, intermittently.
Relocate and contrive rental homes in Salesville United States and Salesville United States holiday rentals.
Commonly, work with, assist, and benefit your possessors, confreres, and twins to a trendy, bewitching, teasing, and trendy principality.
Observe and come across homes for rent Cable and Cable United States rental home.
Rental houses Ontario California and Ontario California house rentals
Locate, come across, and uncover for rent by owner homes Quaker City United States, vacation homes for rent by owner in Quaker City, and rental home Quaker City.
Originate and light upon rental houses and homes for rent Buchanan.
See lakefront classified ads, city directories, and hillside listed properties that property owners and real estate brokers post on FRBO.Com, For Rent By Owner,.
|
|
