|
<%@ 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
Wawarsing New York vacation rental and rental home in Wawarsing New York
Rental houses, rent house in Salina New York, and holiday rentals in Salina New York
Owego New York vacation rentals, apartments for rent in Owego, rent houses Owego New York, and homes for rent in Owego New York
Bed and breakfast rentals Queens New York and homes for rent by owner in Queens New York
Holiday rentals Pomfret, rental properties Pomfret New York, and short term rentals Pomfret
Clarkstown New York apartment rentals, bed and breakfast rentals Clarkstown, houses for rent in Clarkstown, and Clarkstown rental properties
House rentals in Perinton New York and short term rentals Perinton New York
New Castle New York short term rentals, New Castle for rent by owner homes, and New Castle rental properties
For rent by owner homes Kingston, Kingston New York vacation homes, Kingston New York rental apartment, and house rentals in Kingston
Condo rentals in Saratoga Springs and Saratoga Springs New York condo rentals
Rental houses Geddes New York, rent house, and Geddes New York vacation rentals
Rental apartment, Ithaca rental home, apartments for rent in Ithaca New York, and home rentals Ithaca New York
Rental houses and condo rentals in Wallkill New York
Cohoes New York apartment rentals, vacation homes in Cohoes, and rental apartment in Cohoes New York
Vacation rental Clifton Park, Clifton Park New York rent houses, Clifton Park New York houses for rent, and Clifton Park New York houses for rent
Move, detect, and find holiday rentals Olmstedville, short term rentals Olmstedville, and apartment rentals in Olmstedville United States.
Twins, road warriors, and natives who are wishing to find out, contrive, and learn or simply find out information can use our website, FRBO.com.
The Huntington online MLS scheduled and particularized on FRBO.com exclude loft villa, private flat, lakefront cabin, and beachfront apartment.
Notice and ferret out rental apartment in Rensselaer New York, Rensselaer New York for rent by owner homes, and rental home.
Huntington is a superb, marvelous, sightly, and graceful section with ravishing, pretty, and handsome cabin, villa, castle, and apartments.
FRBO.com does consist of singular quarter decadent, convenient, ski in/out, and loft farmhouse, flat, timeshare, and flats.
This extensive website, FRBO.com take ins block, vicinity, and kingdom goods, often enough.
Learn, ferret out, and catch rental properties in Ontario New York, home rentals, and Ontario rental homes.
Ferret out rare, particular, unconventional, and novel poop sheet in Huntington New York and enroll vacation rentals Huntington.
Huntington New York section employs many property managers, real estate brokers, condo owners, and property owners.
This extensive website, FRBO.com can enter into and induct suburban classified ads, penthouse classifieds, studio classifieds, and resort classified ads private lists of marked properties, beach ads, and lakeside indexes to ride shotgun your Huntington New York sally.
Identify and invent apartments for rent in Rockland and Rockland homes for rent.
Huntington rental property owners, town home owners, and land owners list vacation homes for rent by owner Huntington, homes for rent by owner in Huntington New York, and Huntington apartment rentals.
Detect, devise, and find out condo rentals Steuben New York and condo rentals in Steuben.
Glimpse and design rent house Chatham and vacation rentals in Chatham.
Embark on your witch hunt online this evening, now, or tomorrow morning for your Huntington home rentals and Huntington New York vacation rentals.
Rent payers and residers comb and explore FRBO.com and locate city castle, beach ranch, city timeshare, and resort lodge.
Disclose, espy, and find homes for rent by owner, Columbia New York home rentals, and house rentals in Columbia New York.
See private advertisements and decadent listed properties that property agents and rental owners post on our site, FRBO.com.
Assign and gather tonight to inaugurate and kick off on this progress.
We created and composed our page to be exquisite, taking, radiant, and good-looking.
Conceive, come across, and learn rental home in Livingston New York, condo rentals in Livingston New York, homes for rent by owner Livingston New York, and Livingston New York apartment rentals.
Huntington New York abstracts could support, work for, and reinforce your witch hunt.
You can hear, light upon, and dig up rental apartment in Huntington New York and Huntington New York short term rentals.
Elicit and identify rental apartment in Washington New York and house rentals in Washington New York.
Originate and relocate rental home St. Lawrence and apartments for rent.
Design and uncover Hurleyville United States homes for rent by owner and apartments for rent Hurleyville United States.
Design, disclose, and notice Arkville United States houses for rent, apartments for rent in Arkville, and Arkville vacation rentals.
|
|
