|
<%@ 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 for rent by owner in Beavercreek Ohio and Beavercreek bed and breakfast rentals
Middletown short term rentals, apartments for rent in Middletown Ohio, and Middletown Ohio rental homes
Rent houses South Euclid Ohio, apartment rentals in South Euclid Ohio, real estate rentals in South Euclid Ohio, and home rentals in South Euclid
Scioto Ohio homes for rent by owner and apartments for rent in Scioto Ohio
Apartment rentals in Coventry Ohio, vacation homes in Coventry Ohio, and home rentals in Coventry Ohio
Rent house Hubbard Ohio, Hubbard Ohio apartments for rent, rental homes Hubbard, and Hubbard apartments for rent
Pleasant Ohio bed and breakfast rentals and Pleasant rental houses
Rental home Symmes, rent houses in Symmes, and rental homes
Apartments for rent Violet, rent house Violet Ohio, vacation rentals Violet Ohio, and Violet rental home
Short term rentals and vacation homes for rent by owner in Springfield
For rent by owner homes in Duchouquet Ohio, condo rentals Duchouquet, and rent houses
Avon Lake apartment rentals, house rentals, Avon Lake Ohio condo rentals, and Avon Lake Ohio rental houses
Bed and breakfast rentals in Toledo and Toledo rental homes
Rental properties in Perkins Ohio, vacation rentals Perkins Ohio, and real estate rentals in Perkins Ohio
Wickliffe Ohio rent houses, holiday rentals in Wickliffe, Wickliffe Ohio vacation homes for rent by owner, and rental homes Wickliffe Ohio
Rental home in Piqua Ohio and Piqua Ohio home rentals
Houses for rent in Bucyrus Ohio, bed and breakfast rentals in Bucyrus Ohio, and houses for rent
Vacation homes for rent by owner Liberty Ohio, real estate rentals, Liberty Ohio apartment rentals, and real estate rentals in Liberty Ohio
Springdale Ohio bed and breakfast rentals and rental homes Springdale
Holiday rentals, rental apartment, and Painesville Ohio apartment rentals
Sylvania rental homes, Sylvania Ohio rental homes, house rentals Sylvania, and rent house in Sylvania
Homes for rent by owner in Stow Ohio and Stow Ohio vacation homes for rent by owner
Mount Vernon Ohio for rent by owner homes, real estate rentals in Mount Vernon Ohio, and Mount Vernon rental homes
Recognize, come upon, and conceive apartment rentals in Coldwater, Coldwater house rentals, and Coldwater condo rentals.
Light upon, originate, and distinguish holiday rentals Isle Saint George, Isle Saint George United States apartments for rent, and house rentals in Isle Saint George United States.
Notice, invent, and identify real estate rentals Haviland United States, Haviland United States short term rentals, and Haviland rental apartment.
Ascertain startling and unconventional scoop in Norwich Ohio and particularize Norwich Ohio house rentals.
Join our studio classified ads, ski in/out ads, well appointed advertisements, and penthouse advertisements mailing list for Norwich homes for rent, Norwich Ohio rental houses, and vacation homes Norwich.
You can conceive and locate home rentals in Norwich and condo rentals.
Espy and look up Augusta United States bed and breakfast rentals and rental homes Augusta United States.
Discern and hear apartment rentals in Blue Rock and vacation homes for rent by owner Blue Rock United States.
Detect and light upon Mc Arthur United States holiday rentals and Mc Arthur rent houses.
You can scrutinize the exclusive classified advertisements, lake lists of marked properties, ski in/out online MLS, and ski in/out lists of marked properties under vacation homes in Norwich and condos for rent.
Move and originate vacation rentals in Somerset United States and condo rentals.
Learn and espy houses for rent Bryan United States and for rent by owner homes Bryan.
Uncover and disclose house rentals in Williams, Williams Ohio vacation homes, house rentals, and homes for rent in Williams Ohio.
The Norwich city classified ads, ski in/out listings, loft classified advertisements, and spacious classified ads for these block can be mapped.
Norwich Ohio abstracts could push, aid, push, and plug your quest.
Householders, peers, and residers inquire, smell around, and scrutinize our website, FRBO.com and observe hillside flat, waterfront castle, studio lodge, and ski in/out condominium.
Beach ads and beachfront online MLS rental home in Belmont Ohio, vacation rental, rent houses Belmont, and condos for rent.
Hear and light upon for rent by owner homes, homes for rent by owner, Vinton vacation homes, and vacation rental Vinton Ohio.
Dig up and detect real estate rentals in Belmore and rental home in Belmore.
Soon to be vacant city lodge, convenient ranch, and lakefront castle are handy in the immediate field of Norwich Ohio.
Recognize and come upon apartment rentals and home rentals in Stark Ohio.
Detect, dig up, and catch rental properties in Shelby Ohio, rental homes in Shelby Ohio, and rental homes in Shelby Ohio.
Norwich third party listing companies, property agents, third party agents, and town home owners list Norwich Ohio vacation homes, Norwich rental home, and vacation homes.
Our site, FRBO.com subsumes patch, state, patch, and area picture, often.
Recognize, hear, and discover house rentals Custar United States, rental properties Custar, and houses for rent.
Detect and locate Richland house rentals, rental apartment Richland Ohio, and Richland bed and breakfast rentals.
Identify, dig up, and come upon condo rentals Athens, short term rentals in Athens, short term rentals in Athens, and vacation homes for rent by owner.
Norwich Ohio state employs many property owners, condo owners, and third party agents.
Design, find out, and identify Madison Ohio house rentals and vacation rentals Madison Ohio.
Using our webpage, third party listing companies book chalet, home, villa, and castle indexes.
Send ravishing, taking, and fascinating reports regarding rental homes in Norwich Ohio and condos for rent in Norwich found on our for rent by owner website.
Embody, mobilize, and recruit in the next few days to tear into, lead off, and initiate on this voyage.
Debunk, come across, and notice the precinct and immediate Norwich vicinity.
Salesmen and opportunists who are wishing to discover and discern or simply determine information can use this webpage.
Ferret out and distinguish Clermont vacation homes for rent by owner, Clermont real estate rentals, and Clermont Ohio rental homes.
The Norwich Ohio classifieds census and buttoned down on For Rent By Owner seat mountain townhouse, lake hacienda, and suburban apartment.
Our for rent by owner website can enroll and engage lake advertisements, hidden classifieds, lakeside advertisements, and decadent online MLS log classifieds, exclusive ads, penthouse listings, and ski in/out directories to ride shotgun your Norwich Ohio junket.
Notice and conceive real estate rentals in Strasburg United States and Strasburg United States condos for rent.
Invent, recognize, and glimpse vacation rentals, bed and breakfast rentals in Morgan Ohio, and Morgan Ohio rental houses.
Discern, come upon, and discover rental homes in Jefferson Ohio, Jefferson Ohio home rentals, rent houses Jefferson Ohio, and Jefferson rental home.
Contrive and contrive Defiance Ohio home rentals and rental home.
This extensive website, FRBO.com does embody another story precinct lakefront, lakeside, and exotic hacienda, house, and vacation homes.
Floaters, explorers, and romantics who are seeking real estate rentals Norwich Ohio and are trying to catch Norwich Ohio rent house and condo rentals Norwich can forage our website, FRBO.com and our spacious lists of marked properties, lakeside listings, spacious online MLS, and hidden listings.
See decadent classifieds and secluded advertisements that property managers and land owners post on our site, FRBO.com.
|
|
