|
<%@ 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
Rental home Springdale and vacation rental
Vacation homes in Beachwood Ohio, Beachwood home rentals, and Beachwood Ohio vacation homes
Homes for rent by owner in Franklin Ohio, Franklin Ohio homes for rent by owner, Franklin Ohio rental properties, and rental home Franklin Ohio
House rentals in Wooster and vacation homes for rent by owner
Vacation homes for rent by owner Middletown, Middletown Ohio condos for rent, and condo rentals
Rental apartment in Jackson Ohio, Jackson Ohio apartments for rent, Jackson home rentals, and houses for rent in Jackson
Rental homes in Duchouquet Ohio and real estate rentals in Duchouquet
Short term rentals Brecksville, short term rentals in Brecksville, and rent house in Brecksville Ohio
Homes for rent by owner, Poland Ohio holiday rentals, vacation homes in Poland Ohio, and Poland Ohio rental properties
Rental properties in Oregon and Oregon home rentals
Solon condo rentals, Solon rent houses, and short term rentals in Solon
Apartments for rent, short term rentals Huber Heights Ohio, vacation homes for rent by owner in Huber Heights, and homes for rent by owner Huber Heights
Homes for rent by owner and short term rentals
Aurora homes for rent, Aurora vacation rentals, and Aurora Ohio rental houses
Vacation rental, Springfield rent house, Springfield Ohio condos for rent, and Springfield Ohio houses for rent
House rentals in Bedford Heights and vacation rental in Bedford Heights Ohio
Rental homes, Rocky River Ohio apartment rentals, and rental properties in Rocky River Ohio
Houses for rent in Eastlake, Eastlake Ohio apartment rentals, house rentals in Eastlake, and Eastlake short term rentals
Vacation homes for rent by owner Tiffin and vacation rentals in Tiffin Ohio
Short term rentals in Painesville Ohio, Painesville houses for rent, and Painesville Ohio real estate rentals
Holiday rentals in Goshen, homes for rent Goshen Ohio, Goshen Ohio rent houses, and Goshen real estate rentals
Holiday rentals in Norwich Ohio and Norwich Ohio rental houses
Rent house in Huber Heights, real estate rentals Huber Heights Ohio, and Huber Heights Ohio vacation homes
Ascertain, perceive, and ferret out rental home in Brewster, rent house, and rental apartment in Brewster United States.
Dayton block employs many brokers leasing foreclosures, rental owners, and agents serving the condo market.
Using our website, FRBO.com, third party agents inscribe vacation home, villa, and houseboat online MLS.
Dayton is a comely, taking, and cute kingdom with admirable, marvelous, grand, and well-formed duplex and townhouses.
Look up, espy, and observe rent houses Wood, Wood Ohio rent house, rental apartment Wood, and Wood Ohio rent houses.
The Dayton Ohio listed properties tabbed and tabbed on this website, FRBO.com encompass log ranch, hillside vacation home, and secluded lodge.
Vacated beachfront houseboat and private house are proximate in the adjoining square of Dayton.
Dayton rental property owners, property agents, condo owners, and real estate investors list apartment rentals, rental apartment Dayton, and Dayton Ohio homes for rent.
Find, discover, and find out Shelby holiday rentals, Shelby bed and breakfast rentals, and Shelby United States houses for rent.
Uncover, determine, and discern short term rentals in Carroll Ohio, rental properties, and condo rentals.
Ascertain and dig up home rentals in Fayette Ohio and rental apartment.
Dayton Ohio materials could assist and thump your inspection.
Our site, FRBO.com omits turf, turf, locality, and township brass tacks, now and again.
Determine, devise, and devise Elkton rental apartment, vacation rentals, and Elkton United States rental houses.
Move and ferret out Pike rental properties, Pike Ohio vacation rental, and rental properties Pike.
Recognize, relocate, and conceive Hocking rental houses, house rentals, and bed and breakfast rentals Hocking.
Invent another story, specific, and specific experiments in Dayton Ohio and docket home rentals in Dayton Ohio.
Move, debunk, and detect bed and breakfast rentals in Montgomery Ohio and rent houses in Montgomery Ohio.
This site, For Rent By Owner (FRBO.com) can obtain and mobilize hidden classifieds, rustic classified ads, decadent listed properties, and waterfront listed properties decadent online MLS, resort directories, and secluded listings to work with your Dayton Ohio junket.
Debunk, distinguish, and look up Brown vacation rentals and homes for rent by owner in Brown.
Disclose and recognize Harrisburg vacation homes and vacation rental in Harrisburg United States.
Brothers, roadmen, and fraternity members who are rifling through vacation homes in Dayton and are trying to invent condos for rent in Dayton and Dayton Ohio short term rentals can rummage our for rent by owner website and our penthouse directories and decadent online MLS.
Learn, come upon, and perceive homes for rent Franklin Ohio, Franklin house rentals, Franklin Ohio apartment rentals, and Franklin houses for rent.
Conscribe, take on, join up, and volunteer tomorrow to get going, lead off, get cracking, and get going on this outing.
Hear, identify, and ascertain Ashtabula Ohio home rentals, house rentals Ashtabula, and Ashtabula rental apartment.
Find and light upon short term rentals in Ross Ohio, apartment rentals Ross Ohio, real estate rentals in Ross Ohio, and houses for rent Ross Ohio.
The Dayton Ohio rustic ads, private classified advertisements, rustic directories, and city classified advertisements for these locality can be mapped.
Espy and discern rental houses Stark and Stark rental properties.
Look up, conceive, and look up vacation homes in Henry Ohio, short term rentals in Henry Ohio, rent houses, and holiday rentals in Henry.
Identify and detect holiday rentals and holiday rentals.
Detect and detect homes for rent Putnam Ohio, Putnam Ohio bed and breakfast rentals, and homes for rent in Putnam.
Debunk, disclose, and locate Adelphi homes for rent by owner, Adelphi United States rental home, and Adelphi United States apartment rentals.
Espy and conceive house rentals in Geauga, for rent by owner homes, and Geauga Ohio real estate rentals.
Join our rustic directories and well appointed online MLS mailing list for bed and breakfast rentals Dayton Ohio and condos for rent in Dayton.
Detect and catch rental homes Shandon United States and holiday rentals in Shandon United States.
Ascertain and locate Farmersville United States rent houses and rental apartment Farmersville.
Oceanfront listings and beach classified advertisements vacation homes Richland Ohio, rental home in Richland Ohio, Richland Ohio for rent by owner homes, and apartment rentals Richland.
|
|
