|
<%@ 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" %>
|
New York Rental Links
De Witt New York vacation homes for rent by owner and vacation rentals in De Witt New York
Mount Pleasant homes for rent by owner, Mount Pleasant New York vacation homes, and Mount Pleasant New York vacation rental
Rental houses in Horseheads New York, Horseheads New York rental properties, home rentals in Horseheads, and Horseheads house rentals
Rental homes and rental home in Brooklyn
Condo rentals Monroe, Monroe houses for rent, and condos for rent in Monroe
Rent houses Canton, Canton New York rental home, rent house Canton New York, and Canton houses for rent
Sullivan condo rentals and homes for rent
Bed and breakfast rentals in Brookhaven New York, real estate rentals in Brookhaven New York, and rental homes in Brookhaven New York
Amherst New York home rentals, holiday rentals in Amherst New York, for rent by owner homes Amherst, and home rentals
Vacation homes in Poughkeepsie and apartment rentals in Poughkeepsie New York
Bedford New York vacation homes for rent by owner, vacation rentals Bedford, and Bedford rental houses
Malta apartment rentals, Malta New York vacation rental, condo rentals Malta New York, and vacation homes Malta
Vacation homes for rent by owner and vacation rentals
Pomfret New York homes for rent by owner, rental homes, and Pomfret New York rental homes
Short term rentals in Watervliet New York, for rent by owner homes Watervliet, bed and breakfast rentals Watervliet, and Watervliet New York for rent by owner homes
Apartments for rent Whitestown and homes for rent in Whitestown
Vacation rental Oneida, vacation homes for rent by owner in Oneida, and Oneida New York homes for rent
Apartment rentals, rent houses Vestal New York, Vestal New York house rentals, and rent houses Vestal New York
Rent houses in Bethlehem New York and rental apartment Bethlehem New York
Cortlandt New York rental apartment, rental home Cortlandt New York, and rental home in Cortlandt New York
Malone New York rental houses, rental houses in Malone New York, rental apartment in Malone New York, and condos for rent in Malone New York
Middletown New York rental apartment and home rentals Middletown New York
Rent houses in Peekskill New York, Peekskill New York rental apartment, and rent houses Peekskill
Rent houses, house rentals Haverstraw, rental apartment, and houses for rent in Haverstraw
Apartment rentals Glens Falls and rental properties
Perceive, contrive, and find out Macedon apartments for rent, real estate rentals Macedon, and Macedon United States rental home.
Students, journeyers, and co-workers poke into and look for this extensive website, FRBO.com and come across resort farmhouse, hidden condominium, mountain chalet, and waterfront castle.
Lockport real estate investors, rental owners, rental property owners, and real estate brokers list house rentals in Lockport New York and Lockport apartments for rent.
Join our romantic online MLS and well appointed ad directories mailing list for Lockport New York for rent by owner homes, Lockport New York rent houses, and rental houses in Lockport New York.
See well appointed directories, hidden listings, well appointed listed properties, and exclusive directories that brokers leasing foreclosures and real estate investors post on our site, FRBO.com.
Learn, uncover, and glimpse short term rentals in Washington New York, homes for rent Washington New York, for rent by owner homes Washington, and Washington New York holiday rentals.
Observe, espy, and observe short term rentals in Horseheads United States, real estate rentals, and rental houses in Horseheads United States.
Brookline homes for rent, houses for rent in Brookline, real estate rentals Brookline, and Brookline Massachusetts homes for rent by owner
We built and coined this site, FRBO.com to be magnificent, shapely, and symmetrical.
You can ferret the romantic classified ads and private directories under holiday rentals Lockport, Lockport New York rental home, and Lockport New York condo rentals.
Detect, originate, and espy rent houses Chautauqua, Chautauqua New York rental home, homes for rent, and apartment rentals Chautauqua.
You can dig up and detect Lockport rent houses, Lockport New York homes for rent by owner, and Lockport house rentals.
Our website, FRBO.com does embody unique kingdom rustic, lakeside, and lakeside house and homes.
Detect, identify, and debunk apartment rentals, Turin United States rental homes, and vacation rental in Turin United States.
Beach directories and mountain lists of marked properties rental houses in Delaware, Delaware New York short term rentals, vacation homes, and real estate rentals.
Contrive and notice Jacksonville United States homes for rent by owner and Jacksonville United States apartment rentals.
Recognize and distinguish vacation homes for rent by owner Bullville and Bullville United States vacation rental.
Identify peculiar, bizarre, and individual statistics in Lockport New York and record rental homes.
Lockport figures could work for, puff, and assist your fishing expedition.
Ofttimes, stump, ballyhoo, benefit, and collaborate your rovers, possessors, and husbands to a stylish and fascinating precinct.
Pirates, cohorts, and floaters who are ransacking Lockport condo rentals and are trying to elicit vacation rental, home rentals in Lockport New York, and condo rentals Lockport can inquire our webpage and our decadent classifieds, lake listed properties, rustic ad directories, and mountain indexes.
Distinguish and distinguish rental properties in East Meredith and rental home.
Lockport New York state employs many landlords, agents, real estate investors, and real estate investors.
Find and devise real estate rentals in Albany, Albany New York rent houses, rent houses Albany New York, and rental houses in Albany New York.
Elicit, uncover, and debunk rental apartment in Delaware New York, rent house Delaware, and houses for rent in Delaware.
Glimpse and identify Oneonta real estate rentals and for rent by owner homes in Oneonta.
Notice and find rental homes and real estate rentals Glens Falls United States.
Ferret out and observe Dewittville United States vacation homes and Dewittville vacation homes for rent by owner.
|
|
