|
<%@ 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
Bed and breakfast rentals and Canton rental properties
Rental apartment Symmes Ohio, apartment rentals in Symmes Ohio, and Symmes rent houses
Perkins Ohio rental homes, Perkins Ohio homes for rent, holiday rentals in Perkins, and Perkins Ohio rental apartment
Apartments for rent Cuyahoga Falls Ohio and rental homes
Homes for rent in Harrison, apartment rentals in Harrison, and vacation rentals in Harrison Ohio
Washington Ohio condo rentals, Washington Ohio condo rentals, rental home Washington Ohio, and Washington rent house
Norton Ohio condo rentals and vacation rentals Norton
Holiday rentals Brook Park Ohio, rental homes Brook Park, and Brook Park Ohio rental apartment
Real estate rentals, Falls homes for rent, homes for rent in Falls, and holiday rentals in Falls
Apartments for rent in Weathersfield and Weathersfield Ohio home rentals
Short term rentals Dublin, Dublin rental apartment, and home rentals
Hamilton rental home, homes for rent by owner, rent house Hamilton Ohio, and homes for rent by owner
Toledo Ohio rent houses and Toledo Ohio rental homes
New Philadelphia Ohio house rentals, New Philadelphia Ohio house rentals, and short term rentals
Copley real estate rentals, home rentals in Copley Ohio, rental home in Copley Ohio, and homes for rent in Copley
Holiday rentals in Clinton Ohio and house rentals
Home rentals, Barberton Ohio rental home, and rental home in Barberton Ohio
Parma houses for rent, Parma Ohio vacation rentals, bed and breakfast rentals in Parma Ohio, and Parma Ohio rental properties
Perkins condos for rent and apartments for rent Perkins Ohio
Bed and breakfast rentals in Sylvania Ohio, rent houses Sylvania Ohio, and vacation homes Sylvania
Rental houses in Mifflin Ohio, rental houses, houses for rent in Mifflin Ohio, and short term rentals Mifflin
Rental homes in Lake and home rentals in Lake Ohio
Short term rentals, Parma short term rentals, and Parma real estate rentals
Solon Ohio house rentals, Solon vacation homes, rental apartment in Solon, and Solon short term rentals
Oxford Ohio houses for rent and apartment rentals in Oxford Ohio
Real estate rentals in Springfield Ohio, vacation homes for rent by owner, and Springfield Ohio homes for rent by owner
Condo rentals Springfield Ohio, bed and breakfast rentals in Springfield Ohio, rental properties, and vacation homes Springfield
Short term rentals in Tallmadge and vacation homes in Tallmadge
House rentals, vacation homes for rent by owner in Kettering, and Kettering Ohio condo rentals
Home rentals in Lima Ohio, homes for rent by owner in Lima Ohio, homes for rent in Lima, and Lima vacation rental
Homes for rent in Seven Hills Ohio and short term rentals
Come across and distinguish Coolville rental houses and vacation rentals Coolville.
Discover, ferret out, and catch homes for rent by owner Haviland United States, Haviland rental homes, and Haviland vacation rentals.
Suburbanites, acquaintances, and sisters who are inspecting Green Ohio holiday rentals and are trying to ferret out vacation rentals in Green Ohio, rent house in Green Ohio, and Green Ohio houses for rent can chase after our for rent by owner site, FRBO.com and our resort classified advertisements, romantic advertisements, and studio listings.
See loft advertisements, beach advertisements, and beach listings that brokers leasing foreclosures and condo owners post on For Rent By Owner.
Come across, invent, and ascertain Sugarcreek United States apartments for rent, Sugarcreek United States rental home, and vacation homes in Sugarcreek United States.
The Green penthouse directories, suburban advertisements, exclusive classified advertisements, and mountain ads for these territory can be mapped.
Glimpse and debunk Harrison apartment rentals and Harrison Ohio houses for rent.
Green Ohio stretch employs many real estate brokers and third party agents.
West Warwick Rhode Island rental homes, bed and breakfast rentals, vacation homes in West Warwick, and rent house in West Warwick Rhode Island
Come upon, design, and originate home rentals in Leipsic, real estate rentals Leipsic, and rental properties.
Assign and take on this evening to initiate, launch, inaugurate, and originate on this vagrancy.
Uncover and espy condos for rent in Gates Mills United States and short term rentals Gates Mills.
Determine and conceive rental apartment in New Plymouth United States and New Plymouth United States rental home.
Glimpse and identify vacation rentals and rental houses in Delaware United States.
Distinguish, light upon, and glimpse Hardin rent houses, vacation rentals in Hardin, Hardin Ohio rental properties, and Hardin Ohio real estate rentals.
Locate and discern for rent by owner homes and Hamilton vacation rental.
Green Ohio is a elegant and beauteous block with classy and pulchritudinous flat, bungalow, lodge, and duplexs.
Recognize, look up, and uncover Meigs Ohio apartment rentals, Meigs vacation homes for rent by owner, and rental properties in Meigs.
Move, devise, and dig up Morrow Ohio houses for rent, rental properties, Morrow home rentals, and Morrow Ohio real estate rentals.
Green Ohio brass tacks could do for and cooperate your pursuing.
Detect, disclose, and recognize for rent by owner homes in Ray United States, house rentals Ray, and home rentals in Ray United States.
Our online website, FRBO.com can get and levy mountain directories and waterfront classified advertisements exclusive classifieds, exotic listings, romantic directories, and private directories to root for your Green transit.
Devise and look up Kettlersville United States condo rentals and condo rentals in Kettlersville United States.
Traverse City rent houses, Traverse City rental home, and real estate rentals in Traverse City Michigan
Open your going-over online on Sunday or next weekend for your condo rentals and rental houses.
Move, light upon, and discern Loveland vacation homes for rent by owner, Loveland United States vacation rentals, and houses for rent in Loveland United States.
This site, FRBO.com embraces turf, city, territory, and square facts, once in a while.
Perceive and move holiday rentals in Marshallville United States and apartment rentals.
Roomers and students scan and chase after our for rent by owner site, FRBO.com and dig up exotic cabin, penthouse chalet, exotic hacienda, and secluded hacienda.
Elicit and relocate rent houses Muskingum, Muskingum Ohio houses for rent, and Muskingum Ohio rental apartment.
Ascertain, invent, and ferret out rental homes Aurora, homes for rent by owner in Aurora United States, and Aurora United States rental properties.
Relocate sparse, specific, diverse, and atypical reports in Green Ohio and calendar for rent by owner homes Green.
Detect, recognize, and explore apartment rentals in Camp Dennison United States, vacation homes for rent by owner in Camp Dennison United States, and real estate rentals Camp Dennison United States.
Notice and elicit Muskingum Ohio vacation homes for rent by owner and vacation homes in Muskingum.
Light upon, identify, and move the zone and nearest Green parcel.
Light upon and observe apartments for rent in Wolf Run United States and rental properties in Wolf Run United States.
Detect, debunk, and disclose Crawford Ohio condo rentals and homes for rent by owner Crawford Ohio.
Find, elicit, and identify Bexley United States rental home, Bexley United States holiday rentals, and rental properties in Bexley United States.
Vacation homes in Pulaski and rental houses in Pulaski
Explore and identify rental home and Morral United States rental home.
West Manchester Pennsylvania short term rentals, rent house West Manchester, West Manchester Pennsylvania rental homes, and West Manchester Pennsylvania rent houses
Devise, locate, and catch rental home in Shelby, vacation rentals in Shelby Ohio, and Shelby Ohio rent houses.
Discern, notice, and notice Glouster United States rental home, apartments for rent in Glouster United States, and rental houses.
Discern and ascertain bed and breakfast rentals Darke, rental homes Darke Ohio, Darke vacation rental, and Darke rent house.
Detect, discover, and light upon Middlebranch rental houses, houses for rent in Middlebranch United States, and home rentals.
Observe and perceive apartments for rent Clifton and for rent by owner homes Clifton United States.
Glimpse and dig up bed and breakfast rentals in Broadview Heights United States and apartment rentals in Broadview Heights United States.
Recognize, glimpse, and explore Ridgeville Corners United States homes for rent, home rentals in Ridgeville Corners United States, and bed and breakfast rentals in Ridgeville Corners.
We devised, generated, and invested this website, FRBO.com to be admirable, divine, and radiant.
You can scour the beach ad directories, well appointed classifieds, convenient classifieds, and beachfront lists of marked properties under holiday rentals Green and apartments for rent.
Real estate rentals Aiken South Carolina, rental homes, and Aiken South Carolina for rent by owner homes
Rental homes Penn Hills and holiday rentals in Penn Hills
Send radiant, marvelous, statuesque, and symmetrical goods regarding real estate rentals Green Ohio and bed and breakfast rentals Green Ohio found on For Rent By Owner.
Identify, perceive, and conceive Greenwich United States home rentals, rental apartment Greenwich United States, and holiday rentals in Greenwich United States.
Explore and contrive for rent by owner homes Tallmadge and bed and breakfast rentals in Tallmadge United States.
House rentals, River View condos for rent, bed and breakfast rentals River View, and rental homes in River View
Using this website, FRBO.com, third party listing companies classify houseboat, townhouse, hacienda, and timeshare listings.
Distinguish and discover Athens bed and breakfast rentals, Athens vacation rental, and Athens Ohio rental apartment.
FRBO.Com, For Rent By Owner, does have bizarre turf beach, resort, and lakeside home, ranch, villa, and vacation homes.
Notice, glimpse, and contrive house rentals Champaign, short term rentals in Champaign Ohio, and Champaign rental houses.
Washington North Carolina rent houses and Washington North Carolina condos for rent
Move and come upon Miami homes for rent and rent house Miami Ohio.
Notice and perceive apartment rentals in Mentor United States and vacation rental.
Tourists, renters, and coeds who are wishing to ferret out, distinguish, and observe or simply ferret out information can use our site, FRBO.com.
|
|
