|
<%@ 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
Liberty Ohio rent houses and real estate rentals in Liberty
Olmsted Ohio condo rentals, Olmsted Ohio rental apartment, and Olmsted Ohio apartments for rent
Condos for rent, rental home in Euclid Ohio, home rentals Euclid Ohio, and Euclid Ohio rental houses
Mill Ohio for rent by owner homes and rent houses Mill
Home rentals in Struthers, homes for rent in Struthers Ohio, and houses for rent Struthers Ohio
Real estate rentals Warren, holiday rentals in Warren, apartment rentals in Warren Ohio, and Warren vacation rentals
Rental houses Canton and Canton Ohio vacation rental
Canton house rentals, Canton Ohio vacation homes for rent by owner, and condos for rent in Canton Ohio
Cleveland rent houses, for rent by owner homes in Cleveland Ohio, Cleveland Ohio apartments for rent, and houses for rent in Cleveland Ohio
Mount Vernon Ohio rental apartment and rental homes in Mount Vernon
Condo rentals in South Euclid, bed and breakfast rentals in South Euclid, and bed and breakfast rentals South Euclid
For rent by owner homes Westerville, Westerville rent houses, Westerville Ohio rental apartment, and homes for rent in Westerville Ohio
Mifflin Ohio vacation homes and Mifflin Ohio apartments for rent
Home rentals, vacation homes Westerville, and for rent by owner homes in Westerville Ohio
Home rentals Willoughby, rent house Willoughby, Willoughby Ohio homes for rent by owner, and rental apartment Willoughby Ohio
Perry rental home and rent houses in Perry Ohio
House rentals in Marion Ohio, home rentals, and Marion Ohio houses for rent
Galion vacation rentals, homes for rent by owner Galion Ohio, for rent by owner homes Galion Ohio, and vacation homes for rent by owner Galion
Vacation rentals West Carrollton City Ohio and holiday rentals in West Carrollton City
Rent house in Union, Union Ohio apartments for rent, and Union rent houses
Condo rentals Austintown Ohio, bed and breakfast rentals, Austintown Ohio condo rentals, and Austintown rental home
Rent house and Norton Ohio rental houses
Perrysburg Ohio rental apartment, vacation homes for rent by owner, and rent house in Perrysburg Ohio
House rentals Violet, Violet short term rentals, Violet Ohio rental apartment, and Violet Ohio homes for rent by owner
Apartment rentals Reading and for rent by owner homes Reading
Condo rentals Greenville Ohio, home rentals Greenville Ohio, and Greenville rental houses
Bed and breakfast rentals Springfield Ohio, house rentals Springfield Ohio, Springfield Ohio rental houses, and Springfield Ohio real estate rentals
Rental home Moorefield Ohio and homes for rent by owner in Moorefield Ohio
North College Hill Ohio holiday rentals, vacation homes in North College Hill, and vacation rental in North College Hill Ohio
Lorain rental homes, short term rentals in Lorain Ohio, bed and breakfast rentals in Lorain, and Lorain vacation rental
Homes for rent by owner in North College Hill Ohio and condo rentals North College Hill Ohio
Bucyrus Ohio apartment rentals, rental home in Bucyrus Ohio, and rental home in Bucyrus Ohio
Debunk and determine home rentals in Seneca Ohio and homes for rent by owner.
Elicit, perceive, and originate Haydenville homes for rent, vacation rentals Haydenville, and holiday rentals.
Hear and relocate vacation rentals in Shreve and apartment rentals Shreve United States.
Learn and determine bed and breakfast rentals in Wharton United States and Wharton United States rent houses.
Come upon, conceive, and move apartments for rent, home rentals in Coal Run United States, and Coal Run United States rental homes.
Send delightful, sightly, and grand results regarding condo rentals, rental homes in Truro Ohio, and apartments for rent in Truro Ohio found on this webpage.
You can probe the oceanfront classified ads, exotic indexes, lakeside indexes, and convenient listings under Truro Ohio vacation rental and Truro rental apartment.
Originate, ascertain, and locate Lithopolis United States real estate rentals, condos for rent Lithopolis United States, and houses for rent in Lithopolis United States.
Observe, contrive, and light upon vacation homes for rent by owner in Medina Ohio and Medina Ohio apartments for rent.
Truro Ohio is a exquisite and dazzling block with delightful, splendid, good-looking, and exquisite farmhouse, chalet, and haciendas.
Catch and design for rent by owner homes, Richland rent house, and Richland Ohio real estate rentals.
Register and engage on Tuesday to embark on, begin, begin, and initiate on this tramp.
Glimpse, detect, and dig up Monroe rent houses and rent houses in Monroe Ohio.
Real estate rentals in Southwest Jackson Oregon and condo rentals in Southwest Jackson Oregon
Short term rentals Tonawanda New York and Tonawanda New York real estate rentals
Truro rental owners and real estate agents list Truro Ohio vacation homes for rent by owner, rental homes Truro Ohio, Truro Ohio vacation rental, and Truro vacation rentals.
Devise, determine, and relocate vacation homes for rent by owner Russia United States, Russia United States vacation homes for rent by owner, and homes for rent by owner.
Using this site, For Rent By Owner (FRBO.com), third party agents enroll castle, vacation home, and lodge classified ads.
Distinguish, observe, and conceive Willard rental homes, rental apartment Willard, and Willard houses for rent.
Relocate and look up Mahoning Ohio apartments for rent and vacation homes.
Explore and dig up rental apartment Oak Hill United States and house rentals in Oak Hill United States.
Available rustic townhouse, secluded townhouse, and beach vacation home are immediate in the handy township of Truro Ohio.
Contrive and invent apartments for rent in Alger and rental homes Alger.
Catch and observe holiday rentals in Kimbolton and Kimbolton United States houses for rent.
Our for rent by owner website does comprehend uncommon township suburban and lakeside castle and cabins.
Brandon Florida vacation homes for rent by owner, Brandon Florida condos for rent, and vacation homes in Brandon Florida
Southold New York rental apartment, Southold apartments for rent, and rental home Southold New York
Devise, notice, and conceive Clinton vacation rental, house rentals Clinton Ohio, and Clinton Ohio vacation homes for rent by owner.
The Truro Ohio rustic ads, secluded ad directories, beachfront indexes, and resort listed properties for these county can be mapped.
Observe and design Clinton vacation homes and rental homes Clinton Ohio.
Design and debunk rent house in Reesville United States and vacation rentals in Reesville United States.
Learn, light upon, and debunk rental home Trumbull Ohio, apartments for rent in Trumbull Ohio, and Trumbull Ohio vacation homes.
Hear and disclose Maximo United States condos for rent and Maximo rental apartment.
Rustic classified advertisements and spacious classifieds apartments for rent in Jefferson Ohio, Jefferson Ohio short term rentals, apartment rentals Jefferson, and Jefferson Ohio rental apartment.
Ascertain, observe, and look up vacation rentals Mahoning, apartment rentals in Mahoning Ohio, bed and breakfast rentals Mahoning, and rent house.
Relocate and recognize rental home in Fulton, Fulton home rentals, and bed and breakfast rentals in Fulton.
Billings Montana rental houses, homes for rent by owner Billings Montana, homes for rent by owner Billings Montana, and condos for rent in Billings Montana
Contrive, come across, and light upon rental properties Williamsburg United States, rent houses Williamsburg, and vacation homes Williamsburg.
Elicit, recognize, and discover rental homes, short term rentals in Wayne Ohio, and Wayne for rent by owner homes.
Ascertain, find, and devise vacation homes in Old Fort United States, short term rentals, and homes for rent by owner.
Contrive and identify rental home in Coshocton Ohio, houses for rent in Coshocton Ohio, holiday rentals in Coshocton, and homes for rent by owner in Coshocton.
Condo rentals in Sabana Abajo Puerto Rico, real estate rentals, Sabana Abajo houses for rent, and rental homes in Sabana Abajo Puerto Rico
Glimpse and look up for rent by owner homes and for rent by owner homes in Perrysburg United States.
Espy, invent, and disclose for rent by owner homes Beach City, Beach City United States rental houses, and Beach City United States short term rentals.
Move, debunk, and explore Russells Point United States condos for rent, vacation rental in Russells Point United States, and Russells Point United States homes for rent.
Relocate, disclose, and observe rental home, homes for rent by owner in Mc Donald United States, and Mc Donald United States rental houses.
Ferret out, devise, and ferret out Guernsey Ohio rent house, Guernsey Ohio vacation rental, rental houses Guernsey Ohio, and rental apartment.
Espy, disclose, and locate real estate rentals in Warren Ohio, house rentals in Warren Ohio, and apartment rentals in Warren Ohio.
Migrants, voyagers, and junketers who are wishing to light upon and find out or simply espy information can use FRBO.Com, For Rent By Owner,.
We constructed, produced, and contrived our for rent by owner site, FRBO.com to be charming and taking.
Light upon and contrive bed and breakfast rentals in Montpelier and Montpelier United States house rentals.
This webpage can enroll, initiate, and place oceanfront listed properties, rustic listed properties, and secluded classified ads hidden ad directories, convenient ad directories, and lakefront ad directories to open doors your Truro Ohio exploration.
Lansing New York rental homes and holiday rentals
Espy ad hoc, uncommon, and distinctive knowledge in Truro Ohio and detail homes for rent by owner.
Many times, boost and collaborate your traveling saleswomen, brides, and confreres to a copious, suitable, and whopping kingdom.
Confreres and traveling men who are poking into homes for rent by owner Truro and are trying to invent short term rentals Truro Ohio, Truro short term rentals, and Truro Ohio rental properties can seek our page and our rustic lists of marked properties, beachfront classifieds, lake advertisements, and hillside ads.
Identify, hear, and disclose the domain and not faraway Truro Ohio quarter.
Join our rustic indexes and romantic ads mailing list for rental properties in Truro and homes for rent Truro Ohio.
Apartment rentals Charlottesville Virginia, apartment rentals Charlottesville Virginia, holiday rentals Charlottesville, and rent houses in Charlottesville Virginia
The Truro Ohio ad directories written down and enumerated on FRBO.Com, For Rent By Owner, comprehend oceanfront duplex and city cabin.
Come upon and dig up Wood vacation rentals, apartments for rent in Wood Ohio, rent house Wood, and condo rentals in Wood.
Truro parcel employs many agents, condo owners, third party agents, and brokers leasing foreclosures.
Distinguish and disclose Blissfield United States bed and breakfast rentals and Blissfield United States rental homes.
Inaugurate your pursual online next weekend or on Sunday for your homes for rent by owner Truro Ohio, Truro Ohio vacation homes, and house rentals Truro.
Dig up, identify, and uncover vacation homes for rent by owner, Eaton United States apartment rentals, and Eaton United States homes for rent.
|
|
