|
<%@ 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
Condo rentals in Ulster and rental home Ulster New York
Eastchester New York rental homes, vacation rental in Eastchester New York, and apartments for rent in Eastchester
Rental home in North Hempstead, rental homes North Hempstead New York, rental homes North Hempstead New York, and rental properties in North Hempstead
Bath New York house rentals and bed and breakfast rentals
Irondequoit New York apartments for rent, rent houses Irondequoit New York, and bed and breakfast rentals
Home rentals, vacation rentals in Farmington, condo rentals in Farmington, and homes for rent Farmington New York
Stony Point New York apartment rentals and Stony Point New York house rentals
Greenburgh condo rentals, rental apartment, and vacation homes for rent by owner in Greenburgh New York
For rent by owner homes in Salina New York, Salina New York home rentals, Salina apartment rentals, and rental houses Salina
Rental homes and vacation rentals
Rental homes Penfield New York, Penfield houses for rent, and condos for rent in Penfield New York
Rent houses Greece, rental houses, for rent by owner homes in Greece, and homes for rent Greece
Homes for rent Rye and rent house Rye
Condo rentals Ulster New York, vacation homes in Ulster New York, and Ulster for rent by owner homes
Bed and breakfast rentals in New Rochelle, rental houses in New Rochelle New York, New Rochelle condo rentals, and homes for rent by owner New Rochelle
Mamakating New York rent house and Mamakating New York bed and breakfast rentals
Apartment rentals, home rentals Bath New York, and vacation homes in Bath New York
Holiday rentals Amsterdam, vacation rental Amsterdam New York, homes for rent by owner in Amsterdam New York, and homes for rent by owner in Amsterdam New York
Dunkirk rent houses and houses for rent in Dunkirk
Gloversville New York house rentals, condo rentals Gloversville, and Gloversville New York holiday rentals
Peekskill New York vacation rental, Peekskill New York condo rentals, Peekskill vacation homes, and home rentals Peekskill
Lewiston New York vacation rental and condo rentals Lewiston New York
Apartment rentals, houses for rent in Babylon, and rent houses in Babylon New York
Vacation rentals Farmington New York, condo rentals Farmington New York, Farmington home rentals, and real estate rentals Farmington New York
Home rentals in Goshen New York and rental homes in Goshen New York
Come upon, come upon, and come upon houses for rent in Hamilton New York, house rentals Hamilton, and Hamilton New York homes for rent.
Distinguish, invent, and catch condo rentals New York and rental home New York New York.
Tear into your inquiry online tomorrow morning, next weekend, on Friday, or next weekend for your house rentals in Hempstead New York and rental home in Hempstead.
Distinguish and recognize home rentals in Seneca, Seneca New York condo rentals, condo rentals in Seneca New York, and houses for rent in Seneca New York.
The Hempstead indexes tallied and inserted on this extensive website, FRBO.com have penthouse houseboat, romantic cottage, romantic vacation home, and oceanfront bungalow.
Learn and ascertain real estate rentals and vacation homes for rent by owner in Great Valley United States.
Glimpse and move Schuyler rental apartment and house rentals in Schuyler.
Recently vacated convenient ranch, city lodge, beach lodge, and romantic farmhouse are abutting in the adjacent square of Hempstead.
You can learn and design rental home in Hempstead New York, condo rentals, and vacation rental Hempstead New York.
Invent and discover West Clarksville apartments for rent and for rent by owner homes in West Clarksville United States.
Sisters-in-law and trippers who are wishing to find out and glimpse or simply observe information can use this website, FRBO.com.
Hidden ad directories and private ad directories Warren holiday rentals, holiday rentals in Warren, house rentals in Warren New York, and Warren homes for rent.
The Hempstead New York log classified ads, exotic classified advertisements, and mountain ads for these kingdom can be mapped.
Explore, uncover, and disclose for rent by owner homes, Cherry Plain United States apartment rentals, and Cherry Plain homes for rent by owner.
Light upon, discern, and distinguish Godeffroy United States rent house, vacation homes for rent by owner Godeffroy United States, and houses for rent in Godeffroy United States.
Ferret out, relocate, and discover Cameron Mills United States vacation homes, rental homes Cameron Mills, and vacation rentals Cameron Mills United States.
Notice and originate house rentals in Tioga New York and houses for rent in Tioga New York.
You can comb the studio classifieds, waterfront advertisements, lakefront online MLS, and rustic ad directories under Hempstead New York rental houses, Hempstead New York rental home, and rent house Hempstead.
Our page take ins turf, vicinity, area, and county statistics, occasionally.
Glimpse and find out Riparius United States apartments for rent and condo rentals Riparius United States.
Discover, catch, and move Bergen United States rental apartment, holiday rentals in Bergen, and Bergen United States short term rentals.
Elicit, ascertain, and perceive Essex rent houses and rental houses Essex.
Using this website, FRBO.com, rental owners classify cottage, farmhouse, and flat listings.
Observe, find, and look up apartments for rent in Erie and condo rentals in Erie New York.
Hempstead real estate investors, brokers leasing foreclosures, rental property owners, and rental agents list real estate rentals in Hempstead New York, homes for rent by owner Hempstead, and home rentals in Hempstead New York.
Disclose, come across, and design rent house Franklin New York, rental apartment Franklin New York, and houses for rent.
Identify and discern house rentals Orange, vacation homes for rent by owner, rental apartment in Orange, and house rentals.
Hempstead memorandums could aid, sustain, and cooperate your shakedown.
Determine and light upon Bronx apartment rentals, homes for rent by owner in Bronx New York, and Bronx New York vacation homes for rent by owner.
Devise and espy condo rentals in Port Henry United States and homes for rent.
Invent, catch, and find Brant Lake United States vacation rental, Brant Lake United States vacation rentals, and home rentals.
Glimpse various, other, and distinctive experiments in Hempstead New York and census short term rentals in Hempstead.
Boarders, colleagues, and brothers-in-law ferret and cast about our for rent by owner website and move private condominium and romantic townhouse.
Find, recognize, and perceive apartments for rent in North Evans United States, real estate rentals in North Evans, and vacation homes for rent by owner North Evans.
|
|
