|
<%@ 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
Rental home in Middletown New York and Middletown rental home
For rent by owner homes in Highlands New York, condo rentals, and real estate rentals Highlands
Islip New York house rentals, Islip New York condos for rent, vacation homes for rent by owner, and homes for rent in Islip New York
Colonie New York vacation rentals and Colonie New York holiday rentals
Vacation homes Whitestown New York, rental houses Whitestown, and house rentals
Plattsburgh homes for rent, rental houses in Plattsburgh New York, rental home in Plattsburgh New York, and rental apartment Plattsburgh
Wilton home rentals and for rent by owner homes in Wilton New York
Vacation homes for rent by owner Buffalo, rental home in Buffalo New York, and rent house in Buffalo
Rent houses in Fulton New York, condo rentals in Fulton New York, Fulton real estate rentals, and Fulton rental home
Chester New York bed and breakfast rentals and homes for rent by owner in Chester New York
Highlands homes for rent, vacation rentals, and vacation rentals Highlands New York
Rental home Somers, Somers apartment rentals, condos for rent in Somers, and homes for rent in Somers New York
Home rentals in Fallsburg New York and rental properties in Fallsburg
Scarsdale New York apartment rentals, homes for rent in Scarsdale, and Scarsdale New York vacation rentals
Send well-formed, refined, and handsome reports regarding Moreau rent house, houses for rent Moreau New York, homes for rent in Moreau, and homes for rent by owner Moreau found on FRBO.com.
Determine and devise rental home and condo rentals in Blue Point.
Locate ad hoc, especial, peculiar, and unusual memorandums in Moreau New York and chronicle Moreau New York rental apartment.
Uncover, relocate, and determine vacation rental in Lowman United States, rental properties, and homes for rent Lowman United States.
See secluded ads, rustic ads, private classified advertisements, and beachfront ads that real estate investors and rental property owners post on our for rent by owner site, FRBO.com.
Conceive and observe holiday rentals Yates New York and Yates New York holiday rentals.
Join our city lists of marked properties, rustic online MLS, lake ad directories, and spacious indexes mailing list for vacation homes for rent by owner in Moreau, Moreau New York homes for rent, and Moreau real estate rentals.
Explorers and trekkers who are chasing after real estate rentals in Moreau New York and are trying to discover bed and breakfast rentals in Moreau, Moreau real estate rentals, and vacation rentals in Moreau New York can investigate this webpage and our loft advertisements and resort listed properties.
Uncover, explore, and learn condos for rent, Cortland rental home, rent houses Cortland New York, and Cortland New York vacation homes.
Moreau poop sheet could root for and open doors your chase.
The Moreau New York oceanfront listings, oceanfront advertisements, and ski in/out listings for these quarter can be mapped.
Invent and look up Yates New York homes for rent and rent house.
Kick off your pursual online in the morning, on Sunday, or this evening for your homes for rent by owner Moreau, holiday rentals in Moreau New York, and Moreau New York rental properties.
Devise, originate, and elicit Jefferson New York rental houses and vacation rentals in Jefferson.
Moreau New York is a resplendent and divine county with appealing and good-looking apartment, flat, lodge, and houseboats.
Initiate and appoint on Saturday to originate, lead off, and get cracking on this sally.
Identify, discover, and ferret out Chenango vacation rentals and rent houses in Chenango New York.
Catch and find bed and breakfast rentals, condo rentals in Franklin New York, apartment rentals Franklin New York, and holiday rentals in Franklin New York.
Distinguish and dig up condos for rent West Fulton United States and rental properties.
You can probe the waterfront classified ads, exotic lists of marked properties, spacious advertisements, and secluded indexes under apartments for rent Moreau and vacation rentals in Moreau.
|
|
