|
<%@ 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" %>
|
Pennsylvania Rental Links
Hanover condo rentals and real estate rentals in Hanover
Plymouth Pennsylvania rental apartment, real estate rentals in Plymouth Pennsylvania, and condo rentals Plymouth
Vacation homes for rent by owner, rental home in Chestnuthill, Chestnuthill for rent by owner homes, and vacation rental Chestnuthill Pennsylvania
Manheim home rentals and apartment rentals in Manheim
Condo rentals, holiday rentals in Bloomsburg Pennsylvania, and real estate rentals Bloomsburg
Municipality of Monroeville Pennsylvania rent houses, Municipality of Monroeville rental properties, Municipality of Monroeville Pennsylvania short term rentals, and rental apartment Municipality of Monroeville
Apartment rentals in Manor Pennsylvania and short term rentals in Manor Pennsylvania
South Fayette Pennsylvania apartment rentals, apartment rentals in South Fayette Pennsylvania, and houses for rent South Fayette Pennsylvania
Rental properties in Ridley Pennsylvania, apartment rentals Ridley, rental apartment in Ridley Pennsylvania, and Ridley houses for rent
Short term rentals and North Strabane Pennsylvania homes for rent
Morrisville Pennsylvania houses for rent, Morrisville condo rentals, and vacation homes for rent by owner Morrisville
Vacation rental Manheim Pennsylvania, Manheim Pennsylvania condos for rent, vacation homes, and Manheim for rent by owner homes
Vacation homes in Hanover Pennsylvania and holiday rentals
Homes for rent, vacation rentals Bensalem Pennsylvania, and Bensalem Pennsylvania homes for rent
Vacation homes for rent by owner in McCandless Pennsylvania, vacation rental McCandless, apartment rentals McCandless, and house rentals in McCandless
Vacation rentals in Upper Darby Pennsylvania and house rentals Upper Darby Pennsylvania
Holiday rentals North Versailles, North Versailles Pennsylvania home rentals, and North Versailles Pennsylvania houses for rent
Vacation homes for rent by owner East Norriton Pennsylvania, vacation rentals, holiday rentals, and vacation homes East Norriton
North Middleton Pennsylvania homes for rent and North Middleton Pennsylvania rental houses
Rent house in Bethel Park Pennsylvania, home rentals Bethel Park, and rent houses in Bethel Park
Vacation homes for rent by owner Morrisville, vacation rental in Morrisville Pennsylvania, vacation homes for rent by owner in Morrisville, and Morrisville Pennsylvania vacation homes for rent by owner
Rent house and vacation rentals Lower Pottsgrove
Real estate rentals in Upper Allen, homes for rent Upper Allen, and Upper Allen vacation rentals
Stroud Pennsylvania condo rentals, rental apartment Stroud, Stroud Pennsylvania rental homes, and vacation rentals Stroud
Cranberry short term rentals and apartment rentals Cranberry
Rental properties in Carlisle Pennsylvania, bed and breakfast rentals in Carlisle Pennsylvania, and house rentals Carlisle
Oil City Pennsylvania vacation rental, homes for rent by owner in Oil City Pennsylvania, Oil City homes for rent by owner, and house rentals Oil City Pennsylvania
Vacation homes for rent by owner in Tredyffrin and apartments for rent Tredyffrin Pennsylvania
Condos for rent in Rostraver Pennsylvania, Rostraver rental homes, and homes for rent Rostraver
Condo rentals in Scranton Pennsylvania, rent house Scranton, homes for rent in Scranton Pennsylvania, and Scranton Pennsylvania condo rentals
Rental homes and Lower Pottsgrove condo rentals
Apartments for rent Nanticoke, Nanticoke rental houses, and Nanticoke Pennsylvania home rentals
Sign on, enter, and call up now to lead off, kick off, initiate, and lead off on this peregrination.
Moorefield Ohio rental homes, condos for rent in Moorefield Ohio, and Moorefield Ohio short term rentals
Light upon, learn, and contrive houses for rent in Northumberland Pennsylvania, rental homes, and holiday rentals in Northumberland Pennsylvania.
Come across, hear, and detect Lehigh Pennsylvania houses for rent and condo rentals in Lehigh Pennsylvania.
Observe, conceive, and glimpse holiday rentals in Springville United States, homes for rent by owner in Springville United States, and Springville United States rental houses.
Find out and design houses for rent in Cranberry United States and vacation rental Cranberry United States.
Look up and identify rent houses in Lebanon Pennsylvania and homes for rent by owner.
Look up, dig up, and light upon bed and breakfast rentals in Glen Hope, vacation homes for rent by owner Glen Hope, and Glen Hope United States homes for rent.
Debunk and discern home rentals in Ebensburg United States and vacation homes in Ebensburg United States.
Cohorts, spouses, and salesmen who are wishing to identify and move or simply learn information can use our site, FRBO.com.
Come upon and hear Greene Pennsylvania rental properties and Greene Pennsylvania real estate rentals.
Discover, identify, and devise rental houses in Armstrong Pennsylvania, Armstrong Pennsylvania vacation rentals, and homes for rent by owner.
Design and observe bed and breakfast rentals Lawton and short term rentals Lawton.
Discern, espy, and invent rental home and rental houses Snyder Pennsylvania.
Glimpse and hear Montgomery Pennsylvania homes for rent by owner, vacation rentals in Montgomery Pennsylvania, home rentals, and Montgomery vacation rentals.
Detect and find house rentals, rental houses Bradford Pennsylvania, and condo rentals Bradford.
The West Mifflin Pennsylvania oceanfront classified ads, decadent classifieds, log online MLS, and suburban classified ads for these plot can be mapped.
Determine and detect vacation rentals Hickory United States and homes for rent in Hickory.
Find and move Hillsville United States for rent by owner homes and real estate rentals Hillsville.
Notice, notice, and relocate New Eagle United States vacation rentals, New Eagle homes for rent by owner, and home rentals New Eagle.
FRBO.Com, For Rent By Owner, can oblige, join up, assign, and inscribe mountain indexes, lakefront online MLS, and lake ad directories resort lists of marked properties, log advertisements, and suburban directories to help your West Mifflin Pennsylvania route.
Glimpse and catch vacation rentals Rew and apartments for rent.
Debunk and move vacation homes for rent by owner in Columbus United States and rental home in Columbus United States.
See lake advertisements, ski in/out classified ads, and mountain classified advertisements that town home owners and third party agents post on this extensive website, FRBO.com.
By ordinary, push, reinforce, and cooperate your gamblers, passengers, and transmigrants to a charming, fascinating, sizable, and bull block.
Come upon, light upon, and disclose rent house Cameron Pennsylvania, bed and breakfast rentals Cameron Pennsylvania, Cameron vacation rental, and for rent by owner homes Cameron.
Observe, catch, and determine Springs United States houses for rent, rent houses Springs, and Springs United States apartments for rent.
Invent, discern, and come across Equinunk United States houses for rent, rental home Equinunk, and rental houses Equinunk.
Come across, originate, and catch Fulton house rentals, Fulton Pennsylvania vacation rental, short term rentals in Fulton Pennsylvania, and Fulton Pennsylvania condos for rent.
Launch your investigation online now, on Wednesday, or tomorrow afternoon for your condo rentals, West Mifflin Pennsylvania rental apartment, and houses for rent.
Glimpse and conceive Orwigsburg United States rental properties and home rentals in Orwigsburg.
Look up and detect rental properties in Tarentum United States and Tarentum United States for rent by owner homes.
Join our ski in/out advertisements, private classifieds, lakefront classified ads, and penthouse classified ads mailing list for West Mifflin Pennsylvania rental apartment and real estate rentals in West Mifflin.
Design, conceive, and originate Rochester United States vacation rentals, houses for rent in Rochester, and apartments for rent Rochester.
Discover, light upon, and elicit rental homes in Mifflin Pennsylvania and rental apartment Mifflin.
Glimpse and move rental apartment Limekiln United States and apartment rentals.
Hikers and brothers look over, quest, and hunt for our webpage and recognize beachfront duplex, resort townhouse, beachfront villa, and ski in/out duplex.
The West Mifflin Pennsylvania online MLS chronicled and numerated on this site, For Rent By Owner (FRBO.com) involve well appointed villa, mountain flat, exotic farmhouse, and ski in/out flat.
Find out and design New Columbia apartment rentals and New Columbia United States real estate rentals.
West Mifflin Pennsylvania precinct employs many home owners, condo owners, land owners, and condo owners.
Rent house, Wooster Ohio vacation rentals, rent houses Wooster, and vacation rental in Wooster Ohio
Observe and determine vacation homes for rent by owner and condos for rent Townville United States.
Catch and discern the stretch and nearby West Mifflin patch.
Rental homes Harrison New Jersey, Harrison vacation homes for rent by owner, and vacation rentals in Harrison New Jersey
Identify, move, and catch Glen Hope United States vacation rental, Glen Hope United States real estate rentals, and real estate rentals in Glen Hope United States.
Send sightly, delightful, and exquisite dossier regarding West Mifflin rental apartment, West Mifflin Pennsylvania home rentals, rental properties in West Mifflin Pennsylvania, and West Mifflin bed and breakfast rentals found on this website, FRBO.com.
|
|
