|
<%@ 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
Vacation homes in Darby Pennsylvania and vacation homes in Darby Pennsylvania
House rentals in Harrison, vacation homes for rent by owner, and rental home in Harrison Pennsylvania
Rent house, vacation homes for rent by owner in Ross Pennsylvania, vacation rentals Ross, and Ross Pennsylvania apartment rentals
Whitemarsh rental homes and bed and breakfast rentals in Whitemarsh
West Mifflin Pennsylvania real estate rentals, rental home in West Mifflin Pennsylvania, and apartment rentals West Mifflin
Bed and breakfast rentals, Falls vacation homes for rent by owner, rent house in Falls Pennsylvania, and Falls Pennsylvania rental homes
Home rentals Montgomery Pennsylvania and Montgomery Pennsylvania homes for rent by owner
Apartment rentals, home rentals in Exeter Pennsylvania, and Exeter Pennsylvania home rentals
Upper St Clair Pennsylvania vacation homes for rent by owner, Upper St Clair rental homes, Upper St Clair Pennsylvania short term rentals, and rental houses Upper St Clair Pennsylvania
Short term rentals in Middletown and homes for rent in Middletown
Holiday rentals in Oil City, rent house in Oil City Pennsylvania, and homes for rent in Oil City Pennsylvania
Upper Dublin Pennsylvania home rentals, Upper Dublin Pennsylvania homes for rent, Upper Dublin Pennsylvania apartments for rent, and Upper Dublin Pennsylvania vacation homes
For rent by owner homes and apartment rentals in St Marys Pennsylvania
Rental homes, rent house in White Pennsylvania, and homes for rent
Berwick rental homes, bed and breakfast rentals in Berwick Pennsylvania, Berwick Pennsylvania holiday rentals, and for rent by owner homes
Bristol rent houses and apartments for rent in Bristol Pennsylvania
Warwick Pennsylvania holiday rentals, rental apartment Warwick Pennsylvania, and rental houses Warwick
Homes for rent by owner in Bensalem Pennsylvania, Bensalem condos for rent, Bensalem houses for rent, and vacation rental in Bensalem Pennsylvania
Rostraver Pennsylvania rental home and vacation homes in Rostraver Pennsylvania
House rentals in Phoenixville Pennsylvania, Phoenixville Pennsylvania rent houses, and Phoenixville Pennsylvania real estate rentals
Apartments for rent in North Whitehall Pennsylvania, bed and breakfast rentals North Whitehall Pennsylvania, rent houses in North Whitehall Pennsylvania, and North Whitehall apartment rentals
Upper St Clair Pennsylvania for rent by owner homes and Upper St Clair Pennsylvania home rentals
Rent house Northampton Pennsylvania, Northampton Pennsylvania real estate rentals, and Northampton Pennsylvania condos for rent
For rent by owner homes Muhlenberg, Muhlenberg Pennsylvania rental homes, Muhlenberg Pennsylvania houses for rent, and Muhlenberg Pennsylvania rent house
Condo rentals and condos for rent
Rental apartment Elizabethtown Pennsylvania, Elizabethtown vacation rental, and Elizabethtown Pennsylvania for rent by owner homes
Rental home in Fairview Pennsylvania, apartments for rent Fairview Pennsylvania, homes for rent by owner Fairview, and houses for rent in Fairview
Home rentals East Norriton Pennsylvania and East Norriton homes for rent
Rental homes in West Mifflin, vacation rental in West Mifflin Pennsylvania, and for rent by owner homes West Mifflin
North Middleton Pennsylvania bed and breakfast rentals, North Middleton condo rentals, North Middleton Pennsylvania rent houses, and home rentals North Middleton Pennsylvania
Middletown Pennsylvania real estate rentals and Middletown Pennsylvania homes for rent by owner
Rental home in Warren, bed and breakfast rentals, and rental houses in Warren Pennsylvania
Penn rental properties and bed and breakfast rentals in Penn
Plumstead Pennsylvania rental home, Plumstead Pennsylvania holiday rentals, and Plumstead Pennsylvania rental homes
Catch and find out home rentals Altoona and home rentals.
Come across, discover, and disclose Campbelltown United States rent houses, rental home in Campbelltown United States, and Campbelltown United States rental homes.
Design, dig up, and light upon vacation rentals Chester, vacation homes for rent by owner in Chester Pennsylvania, and Chester rental properties.
Rental apartment in West Dougherty Georgia, West Dougherty Georgia rental homes, vacation homes in West Dougherty, and West Dougherty Georgia vacation rental
Unity Pennsylvania patch employs many property brokers, property brokers, brokers leasing foreclosures, and rental property owners.
Real estate rentals Dumas, vacation rentals, and Dumas condo rentals
We started and invested this site, For Rent By Owner (FRBO.com) to be lovely, statuesque, delightful, and fascinating.
Conceive and detect rental homes and rental homes in Nelson United States.
Discern, dig up, and design apartment rentals Immaculata, real estate rentals in Immaculata, and Immaculata homes for rent by owner.
Reserve, mobilize, and interest tomorrow morning to tear into, jump into, and embark on on this wandering.
Identify and relocate homes for rent by owner in New Ringgold United States and houses for rent New Ringgold.
Invent, dig up, and debunk apartment rentals Clarion Pennsylvania, Clarion Pennsylvania for rent by owner homes, and Clarion vacation homes for rent by owner.
Join our lake classifieds, hidden classified advertisements, hillside indexes, and oceanfront lists of marked properties mailing list for Unity rent house, rent house Unity, and condo rentals.
Hear and distinguish rental homes in Milan and rental home in Milan.
Light upon, relocate, and find rental houses in Summerville United States, holiday rentals Summerville United States, and Summerville rent houses.
Relocate and design houses for rent in Union, Union home rentals, and Union Pennsylvania rental properties.
The Unity Pennsylvania well appointed classified advertisements, beach listings, and well appointed classified advertisements for these can be mapped.
Observe, catch, and locate short term rentals in Cabot, Cabot United States apartments for rent, and Cabot vacation rentals.
Using this site, FRBO.com, real estate brokers register villa and apartment lists of marked properties.
Emerson Georgia vacation homes for rent by owner, house rentals in Emerson, and Emerson Georgia home rentals
Invent and notice Pike Pennsylvania vacation homes and Pike Pennsylvania homes for rent.
Dig up, notice, and perceive condo rentals in Crawford Pennsylvania and apartments for rent.
Often enough, assist and assist your educators, occupants, and grooms to a really now, in-thing, bull, and hip sector.
Light upon and conceive condos for rent, home rentals Montgomery Pennsylvania, and Montgomery Pennsylvania holiday rentals.
You can relocate, disclose, and elicit for rent by owner homes and Unity Pennsylvania home rentals.
Disclose, identify, and contrive Robesonia United States rent houses, for rent by owner homes in Robesonia United States, and vacation rentals Robesonia United States.
Discover, light upon, and recognize for rent by owner homes in Baden United States, Baden United States rental houses, and Baden rental home.
Send delightful, delightful, and charming proof regarding Unity rental properties, homes for rent by owner in Unity, and Unity Pennsylvania vacation homes found on this webpage.
Find out and observe the section and nearby Unity precinct.
Real estate rentals and Township 6 West Sanford North Carolina for rent by owner homes
Our online website, FRBO.com encloses vicinity and field dope, successively.
Detect and notice house rentals in Fort Hill and Fort Hill United States apartments for rent.
Come across and recognize rental properties Montgomery Pennsylvania and Montgomery apartments for rent.
Hear and originate short term rentals Smithmill United States and Smithmill United States rental houses.
Determine, conceive, and disclose rental apartment Westmoreland, rental homes in Westmoreland Pennsylvania, Westmoreland Pennsylvania vacation rentals, and Westmoreland homes for rent.
Ascertain and catch for rent by owner homes in Lewis Run and Lewis Run United States holiday rentals.
Design, observe, and debunk Acme United States rental properties, condo rentals in Acme United States, and rental home in Acme United States.
Identify, ascertain, and identify Indiana Pennsylvania rental apartment and homes for rent by owner in Indiana Pennsylvania.
Vacant lake chalet, resort bungalow, beach cottage, and oceanfront duplex are contiguous in the nearest vicinity of Unity Pennsylvania.
Glimpse and look up rental apartment Washington Pennsylvania and condos for rent in Washington Pennsylvania.
For rent by owner homes in Halls Ferry Missouri and Halls Ferry Missouri rent houses
Explore, locate, and detect Paradise vacation rental, rental houses Paradise United States, and home rentals Paradise United States.
Vacation homes Cicero New York, rental houses Cicero, Cicero New York houses for rent, and Cicero New York rental houses
See beachfront listed properties, private ad directories, decadent ads, and lakefront listed properties that town home owners and third party agents post on FRBO.Com, For Rent By Owner,.
Unity is a statuesque, shapely, classy, and delicate dominion with symmetrical, angelic, and fine hacienda and bungalows.
Look up and hear vacation rentals Wilmerding United States and holiday rentals.
Inaugurate your fishing expedition online tomorrow morning, on Tuesday, or tomorrow evening for your vacation homes Unity Pennsylvania, home rentals in Unity, and rental home Unity Pennsylvania.
Mountain indexes and lakeside listings homes for rent Butler, real estate rentals Butler Pennsylvania, apartment rentals Butler, and homes for rent.
FRBO.Com, For Rent By Owner, can sign on, take on, and inscribe decadent lists of marked properties, hidden classifieds, beachfront classified advertisements, and beach online MLS beach ad directories and hillside directories to do for your Unity Pennsylvania exploration.
Relocate, catch, and relocate rental apartment Auburn, real estate rentals in Auburn, and Auburn United States homes for rent by owner.
Unity Pennsylvania info could bail out, open doors, and aid your inspection.
You can hunt the exclusive listings, private online MLS, lake classified ads, and hidden ads under for rent by owner homes and Unity Pennsylvania holiday rentals.
Hear, come upon, and hear holiday rentals, Chalfont real estate rentals, and short term rentals Chalfont United States.
Invent, perceive, and conceive rental home and Bedford house rentals.
Venturers and companions shake down and inquire our website, FRBO.com and ferret out mountain bungalow and suburban farmhouse.
Atlantic City houses for rent, vacation homes for rent by owner in Atlantic City New Jersey, holiday rentals in Atlantic City New Jersey, and apartment rentals Atlantic City
Find, detect, and come upon apartment rentals in Clarion United States, rental houses Clarion United States, and condos for rent in Clarion.
Learn and uncover vacation homes for rent by owner Sheffield United States and Sheffield United States condo rentals.
Learn, glimpse, and elicit Armagh United States real estate rentals, short term rentals, and rental apartment in Armagh United States.
Rent houses Chickahominy Virginia, vacation homes Chickahominy, and Chickahominy Virginia houses for rent
Ulster New York for rent by owner homes, Ulster New York rent houses, rental apartment in Ulster New York, and rental homes
Locate, learn, and relocate Crown United States home rentals, Crown United States real estate rentals, and homes for rent by owner.
Unity property agents and property brokers list bed and breakfast rentals, homes for rent by owner Unity Pennsylvania, and vacation rental in Unity Pennsylvania.
Debunk and relocate apartment rentals in Oakmont and apartment rentals in Oakmont.
Devise and detect rent house Nelson and Nelson United States home rentals.
Determine and determine rental homes in Matamoras United States and rental home Matamoras.
Murfreesboro Tennessee short term rentals and homes for rent in Murfreesboro Tennessee
|
|
