|
<%@ 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
Ithaca New York vacation rental and houses for rent
Bed and breakfast rentals Binghamton New York, Binghamton real estate rentals, and Binghamton New York rent house
Pelham New York short term rentals, rental apartment in Pelham New York, vacation homes for rent by owner Pelham, and vacation homes for rent by owner in Pelham New York
Queens vacation homes for rent by owner and Queens New York vacation rentals
Rent houses in Camillus New York, Camillus New York rent houses, and Camillus house rentals
Apartments for rent North Greenbush, vacation homes for rent by owner in North Greenbush New York, bed and breakfast rentals North Greenbush New York, and apartments for rent in North Greenbush
Colonie New York rental homes and Colonie New York vacation homes
Niagara Falls rental properties, vacation rental Niagara Falls New York, and Niagara Falls New York apartments for rent
Rental apartment in Catskill, vacation rentals, Catskill for rent by owner homes, and home rentals Catskill
Condos for rent Arcadia New York and bed and breakfast rentals in Arcadia
Rental homes, condo rentals in Gloversville New York, and apartments for rent Gloversville New York
Real estate rentals in Rotterdam New York, rental homes in Rotterdam, Rotterdam short term rentals, and short term rentals in Rotterdam New York
Apartments for rent in Alden New York and Alden New York rental apartment
Rental home, Huntington New York apartment rentals, and rent houses
Farmington New York vacation rental, vacation homes in Farmington, rent house Farmington, and Farmington for rent by owner homes
Lysander rental homes and holiday rentals in Lysander New York
Rental apartment in West Seneca New York, West Seneca New York rental properties, and apartment rentals in West Seneca New York
Rental houses, homes for rent by owner Glens Falls New York, Glens Falls New York real estate rentals, and Glens Falls condos for rent
Real estate rentals in Clifton Park New York and vacation rental Clifton Park New York
Bed and breakfast rentals, for rent by owner homes in Lancaster New York, and houses for rent Lancaster New York
Huntington short term rentals, condos for rent Huntington New York, Huntington New York rental houses, and house rentals
Vacation homes for rent by owner Amsterdam New York and Amsterdam homes for rent
Lockport home rentals, rental home in Lockport New York, and vacation rentals in Lockport
Rental properties, vacation rentals, homes for rent in Bath New York, and homes for rent by owner in Bath
Short term rentals in Orangetown and Orangetown holiday rentals
Condos for rent in Rye, apartment rentals in Rye New York, and apartment rentals in Rye New York
Vacation homes in Glenville New York, condos for rent in Glenville New York, condo rentals Glenville, and homes for rent by owner
For rent by owner homes in Huntington New York and rental properties in Huntington
Home rentals in Yonkers New York, homes for rent in Yonkers New York, and rental properties in Yonkers New York
Brunswick rent houses, Brunswick New York short term rentals, Brunswick New York rent houses, and home rentals in Brunswick New York
Kingsbury vacation homes for rent by owner and rental home in Kingsbury New York
Find and look up homes for rent Lindenhurst and home rentals in Lindenhurst.
Locate, come upon, and contrive vacation rentals in Cattaraugus and Cattaraugus New York apartments for rent.
Jet-setters and traveling women ransack and forage our webpage and uncover rustic house, city hacienda, decadent home, and ski in/out farmhouse.
Discern, identify, and debunk homes for rent in Willseyville United States, rental houses in Willseyville United States, and vacation homes for rent by owner Willseyville.
Our website, FRBO.com can volunteer, procure, obtain, and gather waterfront ad directories, private classified advertisements, penthouse online MLS, and loft classified advertisements oceanfront online MLS and hidden directories to ballyhoo your Amherst New York survey.
Hidden ad directories and log online MLS Livingston New York apartments for rent, Livingston New York rent house, Livingston New York vacation homes for rent by owner, and rental properties in Livingston New York.
Hear, come across, and move rental houses in Blodgett Mills, condo rentals in Blodgett Mills United States, and Blodgett Mills United States holiday rentals.
Vacation rental and vacation rental in Riverview Michigan
Identify, light upon, and come upon bed and breakfast rentals in Troupsburg United States, rent house Troupsburg United States, and condo rentals Troupsburg.
Disclose and notice home rentals in Rockland New York, condo rentals Rockland New York, and rental apartment.
Catch, locate, and discover apartment rentals Armonk, holiday rentals in Armonk United States, and homes for rent in Armonk.
Ferret out and discern vacation rentals Rye and rental houses.
Find and disclose apartment rentals in Greene New York, homes for rent, and house rentals Greene.
The Amherst New York advertisements inserted and indexed on FRBO.com comprehend hidden timeshare, lakeside townhouse, and beachfront villa.
Join our exotic directories and city directories mailing list for vacation rentals Amherst, apartments for rent, and house rentals Amherst New York.
Jump into your pursual online this evening, now, or in the next few days for your vacation rental, condo rentals Amherst New York, and home rentals in Amherst New York.
For rent by owner homes in Divide Colorado, Divide Colorado rental apartment, rent houses Divide, and home rentals
Home rentals Port Washington, Port Washington Wisconsin vacation homes, and holiday rentals Port Washington Wisconsin
Invent, observe, and determine Ovid United States rent house, Ovid United States apartment rentals, and rental home in Ovid United States.
Find, find out, and learn Schenectady New York bed and breakfast rentals, short term rentals in Schenectady New York, rental home, and apartment rentals.
Relocate specific and sparse evidence in Amherst New York and poll rental home Amherst.
Originate, disclose, and light upon Monroe apartments for rent, Monroe New York rent house, and vacation rentals.
Discover, ferret out, and discover Saint Albans United States short term rentals, vacation homes for rent by owner Saint Albans, and Saint Albans United States condos for rent.
Notice and glimpse vacation homes for rent by owner in Cropseyville and vacation rentals in Cropseyville.
Dig up and conceive Burdett apartments for rent and bed and breakfast rentals Burdett United States.
Espy and recognize homes for rent by owner Columbia and Columbia rental apartment.
Move and come upon Groton United States home rentals and holiday rentals in Groton United States.
Dig up and move vacation homes in Truxton and Truxton houses for rent.
|
|
