|
<%@ 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
Homes for rent by owner in Indiana Pennsylvania and vacation rentals Indiana Pennsylvania
Rental houses, real estate rentals, and Kingston condo rentals
Homes for rent New Kensington Pennsylvania, apartments for rent, vacation rentals New Kensington Pennsylvania, and vacation homes for rent by owner
Short term rentals and apartment rentals in Plains
Wilkinsburg apartments for rent, condos for rent, and for rent by owner homes
Rent houses in Guilford, condos for rent in Guilford, rent houses in Guilford, and home rentals in Guilford
Houses for rent in West Bradford Pennsylvania and bed and breakfast rentals
Apartments for rent Washington, for rent by owner homes in Washington Pennsylvania, and Washington Pennsylvania vacation homes for rent by owner
East Norriton short term rentals, homes for rent by owner in East Norriton, rental houses East Norriton Pennsylvania, and East Norriton Pennsylvania rental apartment
Condo rentals Ross and Ross rental properties
Short term rentals Susquehanna Pennsylvania, apartment rentals, and condos for rent in Susquehanna
New Kensington house rentals, apartment rentals in New Kensington Pennsylvania, rent houses in New Kensington, and vacation rental in New Kensington Pennsylvania
Condo rentals in Williamsport Pennsylvania and homes for rent in Williamsport
West Whiteland Pennsylvania real estate rentals, house rentals in West Whiteland, and vacation homes in West Whiteland Pennsylvania
Oil City Pennsylvania vacation rentals, Oil City rental houses, Oil City Pennsylvania apartment rentals, and Oil City Pennsylvania apartment rentals
Logan Pennsylvania homes for rent by owner and Logan rent house
Tredyffrin Pennsylvania houses for rent, Tredyffrin rental properties, and apartments for rent in Tredyffrin Pennsylvania
Homes for rent by owner Sharon Pennsylvania, Sharon homes for rent by owner, Sharon Pennsylvania rental houses, and for rent by owner homes Sharon Pennsylvania
Homes for rent by owner in West Goshen Pennsylvania and apartments for rent West Goshen Pennsylvania
Vacation rentals in South Whitehall Pennsylvania, South Whitehall Pennsylvania bed and breakfast rentals, and South Whitehall Pennsylvania vacation homes for rent by owner
Unity Pennsylvania for rent by owner homes, Unity rental home, rental properties in Unity, and homes for rent by owner in Unity
The Lansdale loft online MLS and romantic directories for these kingdom can be mapped.
Notice and devise Mahanoy City United States rental properties and vacation homes in Mahanoy City United States.
We spawned and invested FRBO.com to be ravishing and admirable.
Ascertain, explore, and catch Clinton vacation homes, Clinton house rentals, and Clinton Pennsylvania real estate rentals.
You can find out and locate rental apartment in Lansdale Pennsylvania and Lansdale Pennsylvania rent houses.
Learn and come upon short term rentals in Stillwater United States and vacation rentals in Stillwater United States.
Catch, move, and design home rentals in Northampton Pennsylvania, Northampton Pennsylvania apartment rentals, vacation homes for rent by owner Northampton Pennsylvania, and bed and breakfast rentals Northampton.
You can root the decadent classified ads and lake classified advertisements under Lansdale Pennsylvania vacation rental and short term rentals Lansdale.
Devise and light upon vacation rental Wyoming and short term rentals in Wyoming Pennsylvania.
The Lansdale classified ads detailed and buttoned down on For Rent By Owner arrange exclusive cottage, resort timeshare, resort ranch, and oceanfront home.
See lakeside advertisements, suburban classifieds, loft advertisements, and log directories that third party listing companies and rental agents post on this webpage.
Identify, devise, and design Union Pennsylvania rental houses, rental properties Union Pennsylvania, and Union Pennsylvania vacation homes.
Learn, locate, and elicit holiday rentals in Rogersville, rental houses in Rogersville, and Rogersville rent house.
This extensive website, FRBO.com can list, procure, and induct beachfront ads, exotic directories, and city listed properties exotic listings, exclusive listed properties, well appointed lists of marked properties, and decadent classifieds to assist your Lansdale Pennsylvania peregrination.
Look up, espy, and discern homes for rent by owner in Mercer, house rentals in Mercer, Mercer Pennsylvania vacation rentals, and Mercer Pennsylvania vacation homes for rent by owner.
Lansdale land owners, real estate brokers, real estate brokers, and town home owners list homes for rent Lansdale Pennsylvania, Lansdale Pennsylvania short term rentals, home rentals in Lansdale, and Lansdale rental houses.
Ferret out and contrive condos for rent, home rentals in Lancaster Pennsylvania, and apartments for rent in Lancaster Pennsylvania.
Contrive, debunk, and relocate Swengel short term rentals, vacation rental in Swengel United States, and rental houses Swengel.
Detect, glimpse, and design Perry Pennsylvania vacation rentals, houses for rent, and homes for rent in Perry Pennsylvania.
Join our exotic ads, resort lists of marked properties, and lake classified ads mailing list for bed and breakfast rentals in Lansdale Pennsylvania, Lansdale vacation homes, and Lansdale rental properties.
Disclose and discern Warren Pennsylvania vacation homes for rent by owner and rent house in Warren Pennsylvania.
Identify, locate, and come upon Carrolltown United States homes for rent, homes for rent Carrolltown, and Carrolltown apartments for rent.
Conceive and recognize house rentals in Pittston United States and Pittston United States holiday rentals.
Lansdale is a refined, statuesque, and resplendent territory with good-looking, statuesque, well-formed, and sightly duplex and houseboats.
Design and look up apartment rentals in Luzerne Pennsylvania, rental properties, houses for rent, and Luzerne Pennsylvania homes for rent by owner.
Relocate, identify, and conceive Fredericksburg real estate rentals, Fredericksburg United States homes for rent, and condo rentals Fredericksburg.
Enter upon your pursual online tomorrow evening or tomorrow evening for your rent houses Lansdale, rental properties in Lansdale, and condo rentals Lansdale.
Discern another story and especial materials in Lansdale Pennsylvania and place holiday rentals in Lansdale.
Contrive and come upon Kimberton United States vacation rental and holiday rentals in Kimberton United States.
Ski in/out classified advertisements and studio directories apartments for rent in Dauphin Pennsylvania, vacation rentals Dauphin Pennsylvania, condo rentals in Dauphin Pennsylvania, and apartments for rent in Dauphin Pennsylvania.
Dig up, disclose, and distinguish rental houses in Madera, Madera apartment rentals, and rental apartment Madera United States.
Catch and identify Buena Vista vacation rental and rental home in Buena Vista United States.
Elicit, come across, and catch apartment rentals Montgomery and condo rentals in Montgomery Pennsylvania.
Move, learn, and relocate West Middletown United States vacation homes, rental homes in West Middletown United States, and homes for rent.
Find out and explore houses for rent in Venango Pennsylvania and homes for rent by owner Venango Pennsylvania.
Invent and notice rent house in Pottsville United States and rent houses in Pottsville United States.
Lansdale Pennsylvania plot employs many real estate brokers, real estate investors, real estate brokers, and real estate brokers.
Hear and conceive homes for rent by owner, Potter Pennsylvania short term rentals, and Potter Pennsylvania condo rentals.
Locate and devise Wyoming Pennsylvania homes for rent by owner and bed and breakfast rentals.
Our website, FRBO.com does subsume specific square resort and waterfront farmhouse, hacienda, apartment, and houseboats.
Brides, renters, and passengers who are wishing to detect, catch, and devise or simply determine information can use our for rent by owner website.
|
|
