|
<%@ 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
Catskill New York apartment rentals and for rent by owner homes Catskill New York
Apartments for rent in Scarsdale New York, vacation rentals Scarsdale New York, and short term rentals Scarsdale
New Windsor New York vacation rentals, New Windsor New York rent house, New Windsor New York apartment rentals, and New Windsor houses for rent
Gates New York vacation homes for rent by owner and Gates real estate rentals
Riverhead rental properties, rental apartment in Riverhead New York, and rental houses Riverhead New York
Massena New York rent house, condo rentals in Massena New York, rent houses Massena, and Massena New York real estate rentals
De Witt New York condos for rent and condo rentals in De Witt New York
Whitestown short term rentals, rent house Whitestown New York, and Whitestown New York holiday rentals
Short term rentals in Stony Point New York, Stony Point rental houses, rent houses, and Stony Point New York real estate rentals
Eastchester New York for rent by owner homes and real estate rentals
Rent house in Fulton, Fulton New York rent house, and Fulton holiday rentals
Condos for rent in White Plains, White Plains homes for rent, holiday rentals White Plains New York, and White Plains New York vacation rental
Short term rentals in Whitestown New York and rental homes Whitestown New York
East Hampton New York vacation rental, home rentals East Hampton New York, and East Hampton apartment rentals
Penfield for rent by owner homes, Penfield New York home rentals, houses for rent in Penfield New York, and vacation homes Penfield New York
Camillus condo rentals and rental home Camillus
Wheatfield homes for rent, rental home in Wheatfield, and vacation homes for rent by owner Wheatfield
Houses for rent in Southeast, condo rentals in Southeast, home rentals in Southeast New York, and rent house
Condo rentals Southeast New York and homes for rent Southeast
Home rentals in Catskill New York, home rentals Catskill, and vacation homes for rent by owner
Apartments for rent Newburgh, short term rentals in Newburgh New York, Newburgh New York vacation rentals, and rental home in Newburgh New York
Condos for rent Yonkers New York and condo rentals
Wappinger New York rental houses, rent houses in Wappinger New York, and Wappinger New York homes for rent
Apartment rentals New Castle New York, real estate rentals in New Castle New York, New Castle New York bed and breakfast rentals, and rental apartment New Castle
Owego holiday rentals and Owego homes for rent
Vacation homes Beekman, Beekman New York short term rentals, and Beekman apartments for rent
Geddes New York short term rentals, rent houses in Geddes, Geddes New York house rentals, and rental home Geddes
Condo rentals and Mamakating rental properties
Home rentals in Tonawanda, Tonawanda New York homes for rent by owner, and real estate rentals in Tonawanda New York
Rent house in Fulton New York, rental houses, rental properties Fulton New York, and bed and breakfast rentals in Fulton New York
Rental houses and short term rentals in Malta
Mount Vernon New York houses for rent, Mount Vernon New York homes for rent, and rent houses Mount Vernon
White Plains New York rental houses and White Plains New York vacation homes
White Plains New York vacation homes for rent by owner, vacation homes for rent by owner White Plains, and rental properties White Plains
Condo rentals Arcadia, rental apartment in Arcadia New York, real estate rentals Arcadia, and Arcadia New York homes for rent by owner
Our site, FRBO.com does comprise extraordinary domain suburban, city, loft, and lakeside duplex and ranchs.
Holiday rentals in Las Cruces, Las Cruces houses for rent, and Las Cruces New Mexico bed and breakfast rentals
Perceive, ferret out, and originate homes for rent in Amagansett, rental apartment Amagansett, and house rentals Amagansett United States.
Notice and espy rent houses, bed and breakfast rentals in Wyoming New York, and Wyoming New York rental home.
Espy and discern rental houses Congers United States and Congers United States rental home.
Send delightful, dazzling, exquisite, and shapely reports regarding holiday rentals in Cortlandt New York, vacation rental, holiday rentals Cortlandt, and rent houses Cortlandt found on this webpage.
Using our webpage, real estate investors calendar ranch, ranch, cabin, and duplex lists of marked properties.
Mont Belvieu house rentals, holiday rentals in Mont Belvieu, and house rentals Mont Belvieu
Citizens, adventurers, and coeds run down, frisk, and shake down FRBO.com and observe rustic lodge and beach farmhouse.
Observe and identify Sullivan rental home and Sullivan New York rental properties.
Design and locate Orange New York homes for rent by owner, real estate rentals in Orange, and rental properties in Orange New York.
Short term rentals in Cherry Hill New Jersey and vacation homes for rent by owner Cherry Hill New Jersey
Studio listed properties and studio ad directories rental homes in Chenango New York, Chenango apartment rentals, apartments for rent in Chenango New York, and real estate rentals Chenango.
Join our beachfront online MLS and penthouse listings mailing list for vacation homes for rent by owner Cortlandt, Cortlandt New York home rentals, and Cortlandt condos for rent.
Locate, espy, and dig up Oneida for rent by owner homes, home rentals Oneida New York, and home rentals in Oneida New York.
Observe and find Saint Regis Falls United States condos for rent and rental apartment in Saint Regis Falls.
Determine and find apartment rentals in Willsboro United States and house rentals in Willsboro United States.
Debunk, hear, and recognize the domain and handy Cortlandt New York county.
Uncover bizarre, sundry, bizarre, and special compilations in Cortlandt and specify for rent by owner homes.
Recognize and uncover Lynbrook house rentals and rent house in Lynbrook United States.
Identify and light upon Riparius rent house and real estate rentals in Riparius United States.
Ready to move in hidden chalet, convenient ranch, and exclusive castle are nearest in the imminent locality of Cortlandt New York.
Observe and notice rental home Fulton New York, Fulton homes for rent by owner, and vacation rentals.
Find and light upon bed and breakfast rentals Blossvale and rental properties Blossvale United States.
Cortlandt New York township employs many rental owners and third party listing companies.
Catch, relocate, and conceive rent houses Syosset, vacation homes, and for rent by owner homes in Syosset.
Our webpage excludes county, stretch, and township info, occasionally.
Get, serve, join up, and appoint this week to jump into, lead off, and originate on this crossing.
Short term rentals in Tygart West Virginia, condo rentals Tygart West Virginia, real estate rentals in Tygart West Virginia, and vacation homes for rent by owner in Tygart
Cortlandt town home owners, rental owners, real estate agents, and landlords list short term rentals in Cortlandt and rental homes.
Perceive, espy, and learn Peconic United States rental apartment, Peconic United States vacation homes for rent by owner, and Peconic home rentals.
You can disclose and elicit vacation homes for rent by owner Cortlandt and house rentals.
Cortlandt New York is a wonderful and graceful township with statuesque, well-formed, and pleasing townhouse and townhouses.
Discern, conceive, and glimpse rental properties Wyoming, rental home Wyoming New York, and rental apartment in Wyoming New York.
Dig up, design, and dig up apartments for rent, rental apartment Burlingham, and Burlingham United States rental apartment.
Catch, elicit, and devise Fulton New York houses for rent, home rentals Fulton New York, rental homes in Fulton New York, and rental properties Fulton.
Locate, observe, and identify Sauquoit bed and breakfast rentals, rent house Sauquoit, and home rentals in Sauquoit.
Locate, light upon, and devise Willsboro apartment rentals, houses for rent, and vacation homes for rent by owner Willsboro.
We made, composed, and performed our page to be dazzling, charming, marvelous, and pulchritudinous.
Look up and learn Yorktown Heights condo rentals and rental properties Yorktown Heights.
Habitants and troupers who are exploring apartment rentals in Cortlandt New York and are trying to design homes for rent in Cortlandt New York and vacation rental in Cortlandt New York can quest our website, FRBO.com and our lakeside classifieds, exotic ads, beach classified advertisements, and exclusive classifieds.
Rental homes in Southwest and rental homes in Southwest West Virginia
Hear and discern rent houses and rent house in Irving United States.
|
|
