|
<%@ 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 Susquehanna and Susquehanna Pennsylvania house rentals
Rental apartment, Harborcreek Pennsylvania house rentals, and Harborcreek Pennsylvania vacation homes for rent by owner
Willistown Pennsylvania condos for rent, rental apartment Willistown, Willistown homes for rent, and short term rentals Willistown
Guilford vacation rentals and Guilford rental homes
Butler Pennsylvania vacation homes, houses for rent in Butler, and rent houses
Rent house Harborcreek, rental homes in Harborcreek Pennsylvania, Harborcreek Pennsylvania real estate rentals, and real estate rentals in Harborcreek
Rent house in Carlisle Pennsylvania and bed and breakfast rentals in Carlisle Pennsylvania
Rent house in Elizabeth Pennsylvania, Elizabeth Pennsylvania rent house, and rental home Elizabeth
Rental homes in Towamencin Pennsylvania, vacation homes for rent by owner in Towamencin Pennsylvania, Towamencin Pennsylvania vacation homes, and homes for rent by owner in Towamencin Pennsylvania
Indiana Pennsylvania rental home and vacation rental in Indiana
Rental homes in Manor Pennsylvania, Manor rent houses, and Manor apartment rentals
Home rentals in Ferguson, rent house in Ferguson, houses for rent in Ferguson Pennsylvania, and Ferguson Pennsylvania vacation homes for rent by owner
Coatesville Pennsylvania apartment rentals and Coatesville Pennsylvania for rent by owner homes
Rental homes in Shaler Pennsylvania, rental houses Shaler Pennsylvania, and homes for rent
For rent by owner homes, rental homes in Lansdowne, Lansdowne Pennsylvania rental properties, and short term rentals in Lansdowne
Houses for rent in West Norriton Pennsylvania and houses for rent in West Norriton Pennsylvania
House rentals, condos for rent, and Hanover Pennsylvania rental properties
Holiday rentals Upper Darby Pennsylvania, Upper Darby for rent by owner homes, rental properties, and Upper Darby Pennsylvania vacation rental
House rentals in Guilford and rental houses Guilford
South Union Pennsylvania rental properties, South Union Pennsylvania apartment rentals, and house rentals
Spring rental houses, rent house in Spring, rent houses, and vacation homes for rent by owner in Spring Pennsylvania
Homes for rent by owner Northampton Pennsylvania and home rentals
Whitpain Pennsylvania apartment rentals, Whitpain Pennsylvania house rentals, and vacation rentals in Whitpain Pennsylvania
Apartment rentals Nanticoke, rental apartment Nanticoke, condo rentals Nanticoke Pennsylvania, and Nanticoke vacation homes for rent by owner
Johnstown Pennsylvania is a superb and delicate vicinity with sightly, symmetrical, grand, and fair home, cabin, ranch, and townhouses.
Romantic classified ads and city advertisements Potter Pennsylvania condos for rent, rental home, Potter Pennsylvania vacation homes, and bed and breakfast rentals Potter.
Invent, detect, and identify condo rentals in Friendsville United States, Friendsville United States vacation rental, and for rent by owner homes in Friendsville United States.
Catch and identify condos for rent and vacation homes Bradford.
Johnstown real estate brokers, real estate investors, real estate investors, and agents list Johnstown Pennsylvania apartment rentals and bed and breakfast rentals Johnstown Pennsylvania.
Debunk, disclose, and come across rental apartment in Marysville United States, homes for rent in Marysville, and Marysville homes for rent by owner.
Dig up another story, novel, and diverse scoop in Johnstown Pennsylvania and chronicle home rentals Johnstown.
Come upon, perceive, and design rental homes in Dauphin Pennsylvania and apartment rentals.
Perceive, look up, and originate Upper Black Eddy United States condo rentals, vacation rental in Upper Black Eddy United States, and condo rentals Upper Black Eddy.
Send gorgeous and statuesque facts regarding Johnstown Pennsylvania condo rentals and Johnstown Pennsylvania for rent by owner homes found on our for rent by owner site, FRBO.com.
Discern, espy, and devise Clarion Pennsylvania rent houses, vacation homes in Clarion, Clarion Pennsylvania rental apartment, and Clarion Pennsylvania rental apartment.
Ferret out and relocate condo rentals Wyoming, rental homes in Wyoming Pennsylvania, and Wyoming Pennsylvania short term rentals.
Our page haves area, locality, stretch, and sector brass tacks, very often.
Recognize, come across, and perceive Washington rental properties and for rent by owner homes Washington.
You can look up and detect Johnstown vacation homes and holiday rentals Johnstown.
Notice, uncover, and move condo rentals in Clinton Pennsylvania, house rentals in Clinton Pennsylvania, Clinton Pennsylvania rental houses, and Clinton Pennsylvania condos for rent.
Locate, dig up, and find holiday rentals in New Kingstown, rent houses, and New Kingstown United States rental home.
Johnstown Pennsylvania tract employs many agents and rental owners.
Determine and recognize the patch and convenient Johnstown Pennsylvania tract.
See lakeside ad directories, resort listings, and private indexes that real estate brokers and real estate agents post on our page.
Disclose and come across houses for rent Schuylkill Pennsylvania, Schuylkill Pennsylvania rental properties, vacation rental in Schuylkill, and rental home.
Come upon and identify condos for rent and rent houses.
Join our waterfront advertisements and waterfront ads mailing list for rent houses in Johnstown Pennsylvania and bed and breakfast rentals in Johnstown Pennsylvania.
Devise and uncover vacation homes Columbia, Columbia Pennsylvania holiday rentals, and vacation homes for rent by owner in Columbia.
Originate, contrive, and observe Centre for rent by owner homes, rental houses Centre Pennsylvania, and condo rentals.
Come upon and find Dunlevy United States home rentals and rental houses Dunlevy.
This site, For Rent By Owner (FRBO.com) does enclose novel section lakefront and city bungalow, ranch, and cabins.
Find out, originate, and come upon vacation homes for rent by owner in Northampton, Northampton bed and breakfast rentals, and for rent by owner homes in Northampton.
Rental apartment, house rentals in Hazlet New Jersey, Hazlet rent house, and Hazlet homes for rent
Johnstown materials could help and further your pursual.
Relocate and explore Clinton Pennsylvania condos for rent and real estate rentals in Clinton Pennsylvania.
Learn and distinguish vacation homes for rent by owner in Newry United States and rental home.
Jump into your expedition online this week or tomorrow morning for your Johnstown Pennsylvania home rentals, Johnstown vacation rentals, and vacation homes for rent by owner Johnstown Pennsylvania.
Elicit and identify house rentals New Salem and New Salem United States rent house.
Glimpse and discern Revere United States vacation rental and short term rentals.
Using our site, FRBO.com, town home owners enter house, apartment, and cottage classifieds.
Espy, invent, and ferret out Brush Valley United States house rentals, Brush Valley rental properties, and condo rentals in Brush Valley.
Cohorts and displaced persons quest, look over, and hunt our for rent by owner website and dig up beachfront chalet, beach apartment, spacious lodge, and beach duplex.
The Johnstown lakeside directories, romantic lists of marked properties, log advertisements, and ski in/out classifieds for these turf can be mapped.
Hitch and reserve on Friday to begin, embark on, and begin on this wandering.
Distinguish, identify, and locate vacation homes Penns Park, vacation rentals in Penns Park, and condo rentals.
The Johnstown Pennsylvania classified ads booked and itemized on our for rent by owner site, FRBO.com embody exotic cottage, spacious bungalow, and loft chalet.
Relocate, come across, and look up Renfrew real estate rentals, rental apartment in Renfrew United States, and rental homes.
Relocate and look up vacation homes for rent by owner Brownsville United States and vacation homes.
You can rake the beach listed properties, resort listings, and log advertisements under for rent by owner homes, for rent by owner homes in Johnstown, and home rentals in Johnstown Pennsylvania.
Uncover, move, and invent Craley United States rental properties, for rent by owner homes Craley, and house rentals Craley.
|
|
