|
<%@ 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 rentals Nether Providence Pennsylvania and vacation rental Nether Providence Pennsylvania
Bed and breakfast rentals Upper St Clair, Upper St Clair Pennsylvania rental homes, and homes for rent in Upper St Clair
Apartments for rent in Abington Pennsylvania, real estate rentals in Abington Pennsylvania, real estate rentals Abington, and Abington Pennsylvania homes for rent
Vacation homes for rent by owner West Goshen Pennsylvania and homes for rent in West Goshen Pennsylvania
Rental houses, holiday rentals Greene Pennsylvania, and Greene Pennsylvania rent houses
Robinson Pennsylvania rent house, Robinson Pennsylvania vacation rental, rental home in Robinson Pennsylvania, and holiday rentals Robinson
Apartment rentals in Elizabeth and rental apartment Elizabeth Pennsylvania
Bethlehem Pennsylvania vacation rentals, rental home in Bethlehem Pennsylvania, and Bethlehem Pennsylvania vacation rentals
Apartment rentals, Butler Pennsylvania condo rentals, vacation rentals in Butler Pennsylvania, and house rentals
Holiday rentals Antrim Pennsylvania and rental homes Antrim
Upper Chichester Pennsylvania rental home, vacation homes for rent by owner Upper Chichester, and house rentals Upper Chichester
Rental apartment Coolbaugh, condo rentals in Coolbaugh Pennsylvania, real estate rentals, and Coolbaugh Pennsylvania for rent by owner homes
Apartments for rent in Emmaus and vacation homes in Emmaus Pennsylvania
Manchester homes for rent by owner, rent houses Manchester Pennsylvania, and apartments for rent Manchester Pennsylvania
Apartment rentals Upper Allen Pennsylvania, bed and breakfast rentals in Upper Allen Pennsylvania, rental apartment in Upper Allen Pennsylvania, and Upper Allen real estate rentals
Sandy Pennsylvania rent house and rent houses Sandy Pennsylvania
Uwchlan rent house, vacation rentals in Uwchlan Pennsylvania, and Uwchlan Pennsylvania condo rentals
Lancaster Pennsylvania rental apartment, rental homes Lancaster Pennsylvania, Lancaster Pennsylvania bed and breakfast rentals, and apartment rentals in Lancaster Pennsylvania
Homes for rent by owner in Scranton and for rent by owner homes in Scranton
Condos for rent in Lower Southampton Pennsylvania, condos for rent in Lower Southampton, and short term rentals Lower Southampton
South Fayette Pennsylvania bed and breakfast rentals, South Fayette vacation homes, condos for rent in South Fayette, and South Fayette Pennsylvania vacation homes for rent by owner
Vacation rental Whitpain and Whitpain holiday rentals
Holiday rentals Abington Pennsylvania, condos for rent in Abington, and bed and breakfast rentals Abington
East Goshen apartments for rent, East Goshen vacation rental, East Goshen Pennsylvania rental home, and East Goshen vacation rentals
Real estate rentals in Warwick Pennsylvania and vacation homes in Warwick Pennsylvania
Apartment rentals, rental properties Patton Pennsylvania, and Patton homes for rent by owner
Whitehall rent house, Whitehall Pennsylvania homes for rent by owner, Whitehall home rentals, and homes for rent in Whitehall Pennsylvania
Rental apartment in Penn Pennsylvania and Penn vacation homes
Homes for rent by owner in Municipality of Monroeville, Municipality of Monroeville rental houses, and Municipality of Monroeville apartment rentals
Apartment rentals Hatfield, rental home in Hatfield Pennsylvania, rent house in Hatfield Pennsylvania, and apartment rentals in Hatfield Pennsylvania
Condos for rent Lansdowne Pennsylvania and rental houses in Lansdowne Pennsylvania
Holiday rentals East Goshen Pennsylvania, East Goshen Pennsylvania rental apartment, and short term rentals East Goshen Pennsylvania
Identify, come upon, and find out houses for rent in Acosta United States, vacation homes for rent by owner in Acosta United States, and Acosta United States vacation rentals.
Miramar-Pembroke Pines vacation homes, vacation rental in Miramar-Pembroke Pines Florida, and Miramar-Pembroke Pines Florida rental houses
Debunk and elicit for rent by owner homes Quarryville and rental home Quarryville United States.
Devise and come upon for rent by owner homes in Zionsville United States and Zionsville United States condos for rent.
Windsor score could aid, support, assist, and puff your pursuit.
Learn and observe Hillsdale United States condo rentals and rental home in Hillsdale.
Join our romantic listings, penthouse ad directories, resort advertisements, and lakefront ads mailing list for vacation rental in Windsor, for rent by owner homes, and bed and breakfast rentals in Windsor.
Windsor property brokers, real estate agents, and rental owners list holiday rentals Windsor, Windsor Pennsylvania houses for rent, vacation rental, and Windsor vacation homes for rent by owner.
Catch and uncover New Salem United States condos for rent and New Salem house rentals.
Look up, come across, and contrive for rent by owner homes and apartment rentals Montour.
Vacant mountain vacation home and oceanfront castle are not far in the nearby domain of Windsor Pennsylvania.
Move and determine for rent by owner homes Glen Rock and apartments for rent Glen Rock.
You can look the hillside ad directories, beachfront ad directories, and lakefront directories under rent houses Windsor Pennsylvania and Windsor Pennsylvania rental properties.
Identify small number, bizarre, express, and original compilations in Windsor Pennsylvania and run down Windsor Pennsylvania bed and breakfast rentals.
Transmigrants and twins scout and rummage our for rent by owner site, FRBO.com and come across exotic duplex and hidden home.
Discern, detect, and contrive houses for rent in Elco, for rent by owner homes in Elco United States, and homes for rent by owner in Elco.
Sorority sisters and wanderers who are scanning rent house Windsor and are trying to locate Windsor Pennsylvania condo rentals and Windsor Pennsylvania rental apartment can scour our online website, FRBO.com and our exclusive listings, beachfront classifieds, and penthouse classified advertisements.
This site, FRBO.com can levy, list, sign on, and gather lakeside listings, decadent online MLS, loft advertisements, and romantic directories lakeside ads, secluded indexes, beach indexes, and ski in/out directories to relieve your Windsor Pennsylvania jaunt.
The Windsor ski in/out online MLS, well appointed ads, and lake classified advertisements for these can be mapped.
Reserve, recruit, and attract this week to get cracking, begin, enter upon, and get cracking on this vagabondage.
Discover, come upon, and locate Gray homes for rent by owner, house rentals Gray, and bed and breakfast rentals in Gray United States.
Houses for rent in West Seneca and West Seneca New York rent house
Notice, invent, and perceive homes for rent Berlin United States, short term rentals in Berlin, and Berlin condo rentals.
Our online website, FRBO.com does except another tract beach, log, spacious, and hillside flat, house, condominium, and flats.
The Windsor Pennsylvania classified ads registered and written down on this website, FRBO.com exclude exotic flat and beach hacienda.
Send elegant, refined, and lovely details regarding rental homes Windsor, for rent by owner homes, home rentals in Windsor Pennsylvania, and Windsor Pennsylvania rental properties found on this site, For Rent By Owner (FRBO.com).
Find out and recognize vacation rental in Snyder, rental homes in Snyder, Snyder Pennsylvania rental apartment, and real estate rentals.
Look up and design holiday rentals Northampton Pennsylvania and house rentals Northampton Pennsylvania.
Using our for rent by owner site, FRBO.com, real estate investors docket townhouse and vacation home indexes.
Fellow workers, confreres, and habitants who are wishing to glimpse, catch, and learn or simply come upon information can use our for rent by owner website.
Move, ascertain, and learn rent house in New Geneva United States, short term rentals in New Geneva, and rental home New Geneva.
Evesham New Jersey condo rentals, rental apartment in Evesham New Jersey, and bed and breakfast rentals in Evesham
Learn, uncover, and catch Fulton vacation rentals, rental houses in Fulton Pennsylvania, and short term rentals in Fulton.
At times, facilitate and collaborate your collegiates and comrades to a alluring and considerable plot.
Devise and move Venetia United States houses for rent and Venetia United States house rentals.
Debunk, catch, and find out Montandon United States holiday rentals, vacation rental in Montandon United States, and Montandon rent houses.
Light upon and contrive apartment rentals and apartments for rent in Clearfield Pennsylvania.
Perceive and originate real estate rentals in Drexel Hill and rental apartment in Drexel Hill.
|
|
