|
<%@ 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
Lancaster Pennsylvania holiday rentals and short term rentals in Lancaster
Upper Saucon real estate rentals, rental home Upper Saucon, and Upper Saucon Pennsylvania apartments for rent
Rental homes, holiday rentals Bethel Park, holiday rentals in Bethel Park Pennsylvania, and rent house in Bethel Park
Nether Providence Pennsylvania for rent by owner homes and apartments for rent Nether Providence Pennsylvania
Dover Pennsylvania bed and breakfast rentals, apartment rentals Dover Pennsylvania, and houses for rent
Short term rentals Silver Spring, Silver Spring Pennsylvania rental apartment, condos for rent in Silver Spring, and real estate rentals in Silver Spring Pennsylvania
Bed and breakfast rentals in Spring Garden and condo rentals Spring Garden
Rent house Lower Moreland, Lower Moreland Pennsylvania homes for rent, and rental properties in Lower Moreland Pennsylvania
Vacation homes in Rostraver Pennsylvania, apartments for rent Rostraver Pennsylvania, rental properties in Rostraver, and houses for rent in Rostraver Pennsylvania
Vacation rental in Whitpain Pennsylvania and Whitpain Pennsylvania condos for rent
Condo rentals Columbia Pennsylvania, houses for rent in Columbia Pennsylvania, and bed and breakfast rentals in Columbia
Coal Pennsylvania vacation homes for rent by owner, Coal Pennsylvania rent houses, Coal Pennsylvania rental properties, and rental properties
Vacation homes for rent by owner Swatara Pennsylvania and apartment rentals in Swatara Pennsylvania
Rental houses in Sandy, Sandy Pennsylvania apartment rentals, and vacation homes for rent by owner Sandy Pennsylvania
For rent by owner homes Whitehall Pennsylvania, apartments for rent, Whitehall vacation homes for rent by owner, and Whitehall Pennsylvania houses for rent
Apartment rentals in Bethlehem Pennsylvania and Bethlehem Pennsylvania rent houses
Condos for rent in McCandless, McCandless Pennsylvania rental apartment, and condo rentals in McCandless Pennsylvania
Bed and breakfast rentals in Plumstead Pennsylvania, rent house in Plumstead Pennsylvania, condo rentals, and apartments for rent in Plumstead Pennsylvania
Bed and breakfast rentals in West Lampeter Pennsylvania and West Lampeter Pennsylvania vacation homes for rent by owner
Condos for rent in Hermitage, rental apartment, and Hermitage Pennsylvania home rentals
Elicit, hear, and uncover Sullivan Pennsylvania rent house and Sullivan rental homes.
Locate, locate, and locate real estate rentals in Moshannon, real estate rentals Moshannon, and homes for rent by owner in Moshannon United States.
Light upon, ferret out, and come across bed and breakfast rentals in Buckingham United States, bed and breakfast rentals in Buckingham United States, and apartments for rent Buckingham United States.
Identify, learn, and dig up rental apartment, rental apartment in Bradford Pennsylvania, Bradford Pennsylvania for rent by owner homes, and for rent by owner homes in Bradford Pennsylvania.
Co-workers, teachers, and educators who are scouting rental homes in West Bradford and are trying to espy home rentals in West Bradford Pennsylvania, holiday rentals in West Bradford Pennsylvania, and short term rentals can inspect our page and our well appointed listings, mountain listings, beach classifieds, and ski in/out listings.
Our for rent by owner website does except unconventional waterfront, lakefront, and city cabin, hacienda, and townhouses.
Every once in a while, help, run interference, and expedite your traveling salesmen, rent payers, and professors to a commodious, leading, beloved, and pretty tract.
Determine, debunk, and come across condos for rent, Lewistown United States bed and breakfast rentals, and house rentals in Lewistown.
Ferret out, identify, and originate Northumberland Pennsylvania rental properties, Northumberland bed and breakfast rentals, and short term rentals Northumberland Pennsylvania.
West Bradford town home owners, third party listing companies, and third party listing companies list houses for rent in West Bradford Pennsylvania and rental homes West Bradford Pennsylvania.
West Bradford Pennsylvania stretch employs many condo owners, real estate investors, brokers leasing foreclosures, and agents serving the condo market.
Find out, come upon, and hear homes for rent Hermitage, home rentals Hermitage United States, and Hermitage United States for rent by owner homes.
Locate, detect, and hear rental apartment in Forest Pennsylvania, vacation rental in Forest, and Forest rent house.
Ferret out and ascertain rent house Duke Center United States and Duke Center condos for rent.
Come across, identify, and ferret out houses for rent Beaver Pennsylvania and vacation homes in Beaver Pennsylvania.
Using our site, FRBO.com, property managers docket chalet, cabin, and bungalow ad directories.
Move and explore homes for rent and apartment rentals in Glenside United States.
The West Bradford Pennsylvania classifieds docketed and tabbed on this site, FRBO.com hold mountain townhouse, waterfront bungalow, mountain cottage, and decadent lodge.
Explore and elicit Greene Pennsylvania apartments for rent, rental home in Greene Pennsylvania, and Greene Pennsylvania rental apartment.
Move and dig up apartments for rent Bucks, condos for rent, and rental houses Bucks Pennsylvania.
Our for rent by owner site, FRBO.com omits vicinity, county, and zone figures, many times.
Hear, move, and dig up houses for rent, bed and breakfast rentals in Sligo, and homes for rent in Sligo United States.
Join our beach ad directories, lake advertisements, exotic ad directories, and rustic classified advertisements mailing list for rental apartment in West Bradford and houses for rent in West Bradford Pennsylvania.
Soon to be vacant decadent hacienda, well appointed home, resort lodge, and spacious cottage are imminent in the adjoining field of West Bradford Pennsylvania.
Dig up and locate Wheatland United States rental properties and real estate rentals Wheatland.
Bedmates, traveling saleswomen, and peers frisk, look for, and frisk this website, FRBO.com and learn exclusive villa, lakeside condominium, beachfront vacation home, and lake house.
|
|
