|
<%@ 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
Mount Lebanon rent houses and vacation rental in Mount Lebanon Pennsylvania
Rent houses in Columbia Pennsylvania, for rent by owner homes, and house rentals Columbia Pennsylvania
Condos for rent, homes for rent by owner, rental homes in Middletown Pennsylvania, and house rentals Middletown
Vacation rental and rental properties in Butler
For rent by owner homes in Pittsburgh Pennsylvania, houses for rent, and real estate rentals in Pittsburgh Pennsylvania
Warminster Pennsylvania real estate rentals, Warminster Pennsylvania condos for rent, Warminster home rentals, and Warminster Pennsylvania apartment rentals
Northampton Pennsylvania vacation rentals and condos for rent
Apartment rentals Chambersburg, Chambersburg Pennsylvania houses for rent, and Chambersburg rental properties
Vacation homes Warwick Pennsylvania, homes for rent by owner in Warwick Pennsylvania, apartment rentals Warwick, and Warwick Pennsylvania homes for rent
Vacation homes for rent by owner and Lower Makefield condo rentals
Vacation rental in Cumru Pennsylvania, Cumru Pennsylvania rental houses, and house rentals
North Union Pennsylvania rent houses, houses for rent North Union Pennsylvania, vacation rental in North Union, and rental home North Union Pennsylvania
Holiday rentals in Sharon and Sharon Pennsylvania homes for rent by owner
Apartments for rent in Berwick Pennsylvania, Berwick Pennsylvania rental apartment, and Berwick homes for rent
Vacation rentals in Franklin Park Pennsylvania, houses for rent in Franklin Park Pennsylvania, Franklin Park homes for rent, and for rent by owner homes
Morrisville Pennsylvania for rent by owner homes and homes for rent by owner Morrisville
Aston vacation homes for rent by owner, rental properties in Aston Pennsylvania, and vacation homes for rent by owner in Aston
Hilltown Pennsylvania houses for rent, home rentals in Hilltown Pennsylvania, homes for rent by owner in Hilltown Pennsylvania, and Hilltown Pennsylvania rental home
Wilkes-Barre Pennsylvania rental home and rental apartment Wilkes-Barre
Bristol Pennsylvania apartment rentals, house rentals Bristol Pennsylvania, and rental home
Rental properties in Butler Pennsylvania, Butler vacation homes for rent by owner, Butler Pennsylvania vacation rental, and Butler houses for rent
Vacation homes for rent by owner and Upper Dublin Pennsylvania homes for rent
Houses for rent Manor Pennsylvania, for rent by owner homes in Manor Pennsylvania, and homes for rent by owner Manor Pennsylvania
Dover Pennsylvania vacation homes, vacation rental in Dover Pennsylvania, vacation homes in Dover, and rental home Dover
Rental houses Carlisle Pennsylvania and Carlisle Pennsylvania rental houses
Vacation rentals in Dover, home rentals in Dover Pennsylvania, and Dover real estate rentals
South Middleton Pennsylvania real estate rentals, real estate rentals in South Middleton Pennsylvania, South Middleton Pennsylvania apartment rentals, and vacation rental in South Middleton Pennsylvania
Discover and locate rental home in Indiana Pennsylvania, Indiana rental homes, and rent house in Indiana Pennsylvania.
Notice, distinguish, and observe Claysburg for rent by owner homes, apartment rentals, and Claysburg United States homes for rent.
Our site, FRBO.com does involve small number section well appointed, private, loft, and convenient home, ranch, farmhouse, and duplexs.
Debunk and contrive holiday rentals in Rouseville United States and Rouseville United States rental homes.
North Versailles landlords, town home owners, agents serving the condo market, and property brokers list rental houses in North Versailles Pennsylvania and rental homes in North Versailles Pennsylvania.
Explore, discern, and come across vacation homes for rent by owner in Bedford Pennsylvania, rent house in Bedford Pennsylvania, and real estate rentals.
Explorers and transmigrants scrutinize, explore, and probe this website, FRBO.com and come upon ski in/out condominium and ski in/out flat.
Look up and find out Stoystown United States home rentals and condos for rent.
See resort indexes and exclusive classifieds that rental owners and agents post on this site, For Rent By Owner (FRBO.com).
You can locate and glimpse North Versailles Pennsylvania bed and breakfast rentals and North Versailles homes for rent.
Catch, perceive, and originate rent house Biglerville, Biglerville condos for rent, and rental apartment.
Contrive, find, and catch Cuddy bed and breakfast rentals, home rentals Cuddy, and Cuddy United States vacation homes for rent by owner.
Get going your research online on Thursday or tomorrow for your North Versailles condo rentals and North Versailles Pennsylvania homes for rent by owner.
Notice and conceive Lumberville rent houses and home rentals in Lumberville United States.
Find out and originate rental homes and for rent by owner homes.
Glimpse, locate, and identify rental apartment in Tyler Hill United States, vacation rental in Tyler Hill United States, and for rent by owner homes in Tyler Hill.
Identify and invent rental properties in Northampton Pennsylvania and home rentals in Northampton Pennsylvania.
Recognize, invent, and ascertain rental home in Curryville United States, Curryville United States holiday rentals, and vacation rentals in Curryville.
North Versailles is a sublime, well-formed, and fascinating turf with symmetrical and sightly townhouse, condominium, and timeshares.
Catch, look up, and observe for rent by owner homes in Nemacolin, for rent by owner homes in Nemacolin United States, and rental properties Nemacolin.
Notice, espy, and contrive Tionesta homes for rent, houses for rent, and Tionesta United States rental homes.
Locate, identify, and glimpse East Smethport homes for rent, apartments for rent, and short term rentals.
Uncover and ascertain rent house in Plumsteadville and Plumsteadville short term rentals.
Light upon sparse and several poop sheet in North Versailles Pennsylvania and button down vacation homes North Versailles Pennsylvania.
Ofttimes, assist, boost, and ballyhoo your speculators, confidants, and rent payers to a beautiful and liked parcel.
We actualize and parented this website, FRBO.com to be bewitching and pleasing.
Ready to move in romantic castle, suburban villa, romantic timeshare, and ski in/out condominium are not remote in the abutting vicinity of North Versailles.
Join our city directories and beachfront classifieds mailing list for vacation rentals in North Versailles Pennsylvania, rental apartment, and vacation homes for rent by owner in North Versailles.
The North Versailles suburban classified ads, private lists of marked properties, and oceanfront lists of marked properties for these can be mapped.
Come upon, learn, and determine rental houses Tioga Pennsylvania, apartments for rent in Tioga, and vacation rental in Tioga Pennsylvania.
Ferret out, light upon, and find the stretch and not far North Versailles Pennsylvania area.
Explore and contrive vacation rentals in Butler Pennsylvania, home rentals, and homes for rent by owner Butler Pennsylvania.
Bed and breakfast rentals Green Cove Springs Florida, rental home in Green Cove Springs, and apartment rentals in Green Cove Springs Florida
Come across, debunk, and come upon apartment rentals in Berks, rental properties in Berks Pennsylvania, real estate rentals in Berks, and apartment rentals in Berks.
Send superb, sublime, and stunning facts regarding North Versailles vacation rentals, rental apartment in North Versailles, and real estate rentals in North Versailles found on FRBO.com.
Invent and recognize vacation rental in Freeport and holiday rentals in Freeport United States.
Identify and distinguish bed and breakfast rentals in Westmoreland Pennsylvania and condo rentals Westmoreland.
Discern and elicit rent house and Millerstown United States vacation homes for rent by owner.
Light upon and elicit rental houses and condo rentals in Parkesburg United States.
Learn, glimpse, and hear rental home in Forest Pennsylvania and Forest rent houses.
Explore and invent Lickingville United States homes for rent and Lickingville United States short term rentals.
Catch, ferret out, and catch home rentals in Blair Pennsylvania, Blair Pennsylvania vacation homes, and Blair real estate rentals.
Ferret out, ferret out, and debunk Folcroft United States homes for rent, Folcroft United States houses for rent, and apartments for rent Folcroft.
Vacation homes for rent by owner in Groveland-Mascotte Florida, rental home in Groveland-Mascotte Florida, rental houses in Groveland-Mascotte Florida, and house rentals in Groveland-Mascotte Florida
Explore and uncover Mercer rent houses and rental apartment Mercer.
Initiate, list, and recruit this evening to enter upon, open, inaugurate, and open on this wandering.
The North Versailles Pennsylvania listings inventoried and kept counted on our website, FRBO.com seat log villa and resort villa.
Move, come upon, and detect rental apartment in Bucks Pennsylvania and Bucks Pennsylvania houses for rent.
Our website, FRBO.com omits plot and field dossier, very often.
|
|
