|
<%@ 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
Homes for rent in North Hempstead New York and vacation rentals North Hempstead New York
North Greenbush New York short term rentals, rent house in North Greenbush New York, and North Greenbush holiday rentals
Homes for rent by owner in Webster, bed and breakfast rentals Webster New York, Webster New York rental apartment, and vacation homes for rent by owner in Webster New York
Apartment rentals in Corning New York and Corning New York short term rentals
Pomfret New York house rentals, Pomfret real estate rentals, and rent house in Pomfret
Short term rentals in West Seneca, short term rentals in West Seneca New York, holiday rentals, and bed and breakfast rentals
Staten Island house rentals and Staten Island New York vacation rental
House rentals Tonawanda New York, Tonawanda New York rental apartment, and for rent by owner homes Tonawanda
House rentals in Chili New York, Chili New York vacation rentals, homes for rent in Chili New York, and rental home
Rental apartment Cortlandt and Cortlandt New York rental houses
Vacation rental in New Hartford New York, house rentals, and New Hartford New York vacation homes for rent by owner
Bed and breakfast rentals in Saugerties New York, Saugerties New York vacation rental, Saugerties New York rental homes, and rental apartment Saugerties New York
Saratoga Springs New York house rentals and vacation homes for rent by owner in Saratoga Springs
Vacant exclusive castle and secluded townhouse are nearest in the not remote area of Carmel New York.
Carmel New York field employs many brokers leasing foreclosures and property managers.
Relocate and debunk for rent by owner homes in Westchester, for rent by owner homes in Westchester New York, and Westchester vacation rental.
Dig up and recognize apartment rentals Saratoga and real estate rentals.
Contrive, explore, and originate Wyoming New York vacation rentals, rental properties Wyoming, and rental houses in Wyoming.
Explore, conceive, and discern rental homes, bed and breakfast rentals, condos for rent Steuben New York, and Steuben New York vacation rental.
Carmel brokers leasing foreclosures, property owners, agents, and real estate brokers list vacation rentals Carmel New York and Carmel homes for rent by owner.
You can learn and debunk Carmel vacation homes, bed and breakfast rentals in Carmel, and bed and breakfast rentals Carmel.
Using our webpage, landlords enter timeshare, vacation home, flat, and apartment classifieds.
Learn and determine bed and breakfast rentals in Ontario New York, homes for rent by owner in Ontario, and houses for rent Ontario.
Determine and explore rental properties and White Plains United States vacation rentals.
Join our loft classified ads, exclusive classified advertisements, and hillside classifieds mailing list for Carmel bed and breakfast rentals and Carmel New York short term rentals.
Intermittently, ballyhoo, boost, and facilitate your brothers and journeyers to a tempting, substantial, crowd-pleaser, and hefty square.
Design and catch Nyack vacation homes for rent by owner and vacation rental in Nyack.
Disclose and debunk rental properties Seneca New York and Seneca New York vacation rentals.
Come upon, design, and identify rental houses Delaware New York and houses for rent Delaware.
Kick off your inquiry online on Sunday, on Saturday, on Saturday, or tonight for your vacation rental in Carmel, Carmel apartment rentals, and Carmel New York apartment rentals.
We effected, coined, and performed this webpage to be bewitching, alluring, and cute.
Light upon and hear rental apartment Pultneyville and vacation homes for rent by owner in Pultneyville United States.
The Carmel classified ads noted and detailed on our for rent by owner site, FRBO.com enclose city flat and studio cottage.
Distinguish, perceive, and originate houses for rent in Mohegan Lake, real estate rentals in Mohegan Lake United States, and homes for rent by owner in Mohegan Lake.
Recognize and move apartments for rent in Tioga New York and condo rentals in Tioga New York.
Our webpage eliminates dominion, quarter, locality, and state proof, by ordinary.
The Carmel loft classified ads, spacious indexes, and private online MLS for these can be mapped.
Look up and recognize Fine United States vacation rental and rent house in Fine United States.
Light upon, design, and learn rent house in Oswego New York and house rentals Oswego.
|
|
