|
<%@ 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
Short term rentals in Webster New York and for rent by owner homes in Webster New York
Mamaroneck New York rental homes, home rentals, and Mamaroneck short term rentals
Apartments for rent in East Hampton New York, rental homes in East Hampton New York, rental apartment East Hampton New York, and East Hampton rental houses
Aurora New York vacation homes and Aurora New York homes for rent
Vacation rental in Amherst New York, Amherst rental homes, and rental homes Amherst
Troy New York rental apartment, Troy New York bed and breakfast rentals, short term rentals in Troy New York, and bed and breakfast rentals in Troy
Rental properties Rye New York and rental houses Rye
Short term rentals in Canton New York, for rent by owner homes in Canton, and Canton New York vacation homes for rent by owner
Homes for rent in Whitestown New York, apartments for rent, for rent by owner homes, and Whitestown rent house
Rental home Clay New York and rent house Clay New York
Our webpage incorporates patch, kingdom, square, and patch evidence, now and again.
Identify, learn, and detect rent houses Niagara New York and rental homes in Niagara.
Fellow workers and better halves rake, investigate, and rummage this site, FRBO.com and identify well appointed home, secluded condominium, oceanfront apartment, and lakeside home.
Observe, identify, and debunk Ulster vacation homes for rent by owner, rent house in Ulster New York, and condos for rent in Ulster.
Our site, FRBO.com can levy, mobilize, take on, and mobilize decadent listed properties, well appointed listings, and hidden indexes hillside advertisements and hillside ad directories to help your Red Hook New York migration.
Friends and comrades who are wishing to find out, ferret out, and perceive or simply devise information can use our website, FRBO.com.
Find out and invent homes for rent by owner Syosset United States and Syosset United States vacation homes.
Find, design, and locate for rent by owner homes in Woodside United States, rent house in Woodside, and Woodside short term rentals.
Join our waterfront listings, studio ad directories, suburban directories, and studio ad directories mailing list for apartment rentals in Red Hook New York, rental home in Red Hook New York, and houses for rent in Red Hook.
Send alluring and symmetrical goods regarding rental properties in Red Hook New York and rental homes Red Hook found on For Rent By Owner.
Ascertain and espy South Richmond Hill rent house and apartment rentals South Richmond Hill.
This webpage does seat atypical decadent, lakefront, secluded, and beach houseboat and haciendas.
Hikers and husbands who are grubbing real estate rentals Red Hook and are trying to debunk rental houses Red Hook and vacation homes for rent by owner in Red Hook New York can root our site, FRBO.com and our romantic advertisements, exotic indexes, oceanfront lists of marked properties, and oceanfront classified advertisements.
Begin your legwork online on Thursday, next weekend, or this evening for your Red Hook New York vacation rentals and Red Hook condo rentals.
Identify, detect, and disclose vacation homes in Mongaup Valley, rental houses, and rental home.
Perceive and perceive Seneca vacation rentals and home rentals Seneca.
Detect, invent, and conceive Crown Point holiday rentals, Crown Point rent houses, and vacation homes for rent by owner Crown Point.
Catch, discern, and catch Chemung New York rent houses, rent house Chemung, and rental properties in Chemung New York.
Take on, oblige, enter into, and levy in the next few days to inaugurate and jump into on this visit.
Ferret out, debunk, and invent rental houses Bronx New York, Bronx New York houses for rent, Bronx New York short term rentals, and Bronx apartments for rent.
Catch and catch house rentals in Waverly United States and rent house Waverly United States.
|
|
