|
<%@ 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
Webster vacation homes for rent by owner and Webster home rentals
Short term rentals in Blooming Grove New York, vacation rentals in Blooming Grove, and Blooming Grove rental properties
Amherst New York real estate rentals, Amherst New York holiday rentals, home rentals in Amherst New York, and rental homes in Amherst New York
Poughkeepsie New York home rentals and home rentals
East Hampton condo rentals, condos for rent East Hampton New York, and East Hampton rental apartment
Tonawanda New York condo rentals, Tonawanda New York houses for rent, homes for rent by owner Tonawanda, and Tonawanda real estate rentals
Riverhead New York rental homes and homes for rent Riverhead New York
House rentals in Wallkill, vacation homes for rent by owner in Wallkill New York, and bed and breakfast rentals Wallkill New York
Real estate rentals in East Greenbush, homes for rent by owner East Greenbush New York, homes for rent by owner, and East Greenbush New York home rentals
Rental homes in Dunkirk New York and real estate rentals Dunkirk
House rentals in Lackawanna New York, houses for rent Lackawanna, and Lackawanna New York houses for rent
Vacation rentals Yorktown New York, rental properties Yorktown, real estate rentals, and vacation rental Yorktown
Vacation homes for rent by owner in Orangetown New York and vacation homes for rent by owner
Short term rentals, vacation homes in New Hartford New York, and rental properties in New Hartford New York
Bed and breakfast rentals in Chili New York, Chili vacation homes, vacation rental, and Chili rental homes
Clifton Park New York house rentals and vacation rentals in Clifton Park New York
Lewisboro New York homes for rent, houses for rent in Lewisboro, and vacation rental in Lewisboro New York
Condo rentals in Carmel New York, short term rentals Carmel, homes for rent by owner, and Carmel New York rental homes
Short term rentals in Monroe New York and Monroe New York condos for rent
East Greenbush New York condo rentals, East Greenbush rental homes, and rent houses in East Greenbush New York
Bed and breakfast rentals Brookhaven, Brookhaven New York rent houses, Brookhaven New York short term rentals, and rent house Brookhaven New York
Binghamton New York vacation homes and homes for rent in Binghamton New York
Dig up, invent, and ferret out Columbia New York for rent by owner homes and Columbia New York houses for rent.
You can rifle through the well appointed indexes, waterfront online MLS, and spacious listings under vacation rentals in Riverhead New York, vacation homes in Riverhead New York, and rental home in Riverhead.
Devise and find out apartments for rent Retsof United States and Retsof United States rental home.
Recognize, disclose, and debunk Chemung rental houses, Chemung condos for rent, vacation rentals in Chemung, and for rent by owner homes in Chemung.
Beach listings and penthouse ad directories Westchester New York condo rentals, Westchester New York rental houses, Westchester New York rent houses, and vacation rentals in Westchester New York.
Detect and disclose apartment rentals and Boiceville vacation rental.
Discover, devise, and find apartments for rent, rental apartment Yates New York, Yates New York real estate rentals, and Yates real estate rentals.
Conceive and ferret out bed and breakfast rentals in Monroe, Monroe New York vacation homes, and Monroe New York real estate rentals.
You can design and notice apartment rentals Riverhead New York, Riverhead rental houses, and Riverhead New York rental home.
Ascertain and locate Schoharie condo rentals and Schoharie New York house rentals.
Riverhead New York is a fascinating and angelic plot with fine and superb home, lodge, bungalow, and cabins.
Dig up, contrive, and come across homes for rent in Washington, rent house in Washington New York, and rental apartment.
Distinguish and locate rental apartment in Pine Valley United States and Pine Valley apartments for rent.
Riverhead New York parcel employs many town home owners, landlords, rental agents, and land owners.
Using this site, FRBO.com, rental property owners record flat, chalet, and flat advertisements.
Look up, learn, and find out bed and breakfast rentals in Long Lake United States, Long Lake United States homes for rent, and Long Lake United States short term rentals.
Tenants, lodgers, and roommates who are rooting rental home and are trying to perceive Riverhead New York vacation homes and homes for rent in Riverhead New York can rake our for rent by owner website and our waterfront ad directories, ski in/out indexes, convenient ad directories, and oceanfront online MLS.
Identify, catch, and determine Dannemora United States vacation homes, holiday rentals, and apartments for rent in Dannemora United States.
Dig up, disclose, and conceive rental houses in Ulster New York, home rentals Ulster, and Ulster New York condos for rent.
We phrased, formulated, and designed this website, FRBO.com to be cute, resplendent, and sublime.
Design and learn Holley short term rentals and condos for rent in Holley.
Riverhead property managers, real estate investors, property agents, and third party agents list apartment rentals in Riverhead New York and Riverhead house rentals.
Design, relocate, and come upon rental homes Dutchess New York and apartment rentals in Dutchess New York.
Move and notice vacation homes for rent by owner and holiday rentals in South Richmond Hill.
Enroll, muster, employ, and enter tomorrow morning to enter upon and initiate on this promenade.
Riverhead New York score could back and open doors your rummage.
The Riverhead convenient ads, convenient directories, exclusive listings, and decadent listed properties for these section can be mapped.
See log lists of marked properties, city classified ads, decadent advertisements, and beach listings that town home owners and real estate brokers post on our website, FRBO.com.
Discover and find rental houses Poplar Ridge and Poplar Ridge vacation rental.
Locate, uncover, and recognize Orange New York rental homes, Orange New York homes for rent, and rental properties in Orange New York.
Contrive and contrive condos for rent in Erie, apartments for rent in Erie New York, Erie apartments for rent, and vacation rentals in Erie.
Tear into your quest online in the next few days or in the next few days for your short term rentals in Riverhead New York, homes for rent by owner, and Riverhead apartment rentals.
Discover and light upon homes for rent Erin and Erin United States rent house.
Send statuesque, stunning, and well-formed knowledge regarding rental home Riverhead New York, vacation homes for rent by owner Riverhead, condo rentals in Riverhead, and Riverhead rental homes found on this extensive website, FRBO.com.
|
|
