|
<%@ 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 apartment in Cicero and rental apartment Cicero New York
Condo rentals in Auburn New York, Auburn rental apartment, and real estate rentals in Auburn New York
Holiday rentals in Syracuse New York, short term rentals Syracuse, Syracuse short term rentals, and rent houses in Syracuse
Homes for rent Ogdensburg and condo rentals
Salina New York for rent by owner homes, short term rentals, and homes for rent by owner Salina New York
East Hampton New York vacation rental, homes for rent by owner in East Hampton New York, rental properties in East Hampton New York, and vacation rentals in East Hampton New York
Fishkill New York rent house and bed and breakfast rentals Fishkill
Rental houses in Glen Cove New York, for rent by owner homes, and houses for rent in Glen Cove New York
Schenectady New York homes for rent, Schenectady vacation homes, Schenectady rental apartment, and rental homes
Holiday rentals in White Plains New York and rental houses White Plains New York
Condo rentals Schodack New York, home rentals Schodack, and rental home in Schodack New York
Homes for rent Binghamton New York, holiday rentals in Binghamton New York, rental properties in Binghamton New York, and bed and breakfast rentals in Binghamton New York
Rental properties in New Castle New York and New Castle New York vacation rentals
Rental properties Olean New York, vacation homes for rent by owner in Olean, and homes for rent Olean New York
Clifton Park New York rent house, rental home in Clifton Park, for rent by owner homes, and houses for rent in Clifton Park New York
Condo rentals in Beekman New York and Beekman New York rental homes
Rent houses, apartments for rent in Malta New York, and houses for rent Malta New York
Bed and breakfast rentals, home rentals in Blooming Grove New York, short term rentals in Blooming Grove New York, and homes for rent by owner Blooming Grove New York
Lysander holiday rentals and Lysander New York condos for rent
Canton rental apartment, Canton New York rental properties, and vacation rental in Canton New York
Guilderland condos for rent, short term rentals in Guilderland New York, for rent by owner homes, and vacation homes Guilderland
For rent by owner homes Jamestown New York and rent houses
Condo rentals, rental homes Clarkstown New York, and Clarkstown rental home
Houses for rent Hamburg, Hamburg homes for rent, Hamburg New York home rentals, and Hamburg short term rentals
Elma New York houses for rent and for rent by owner homes
House rentals in Montgomery New York, Montgomery condos for rent, and apartments for rent in Montgomery New York
Potsdam apartment rentals, house rentals in Potsdam New York, apartments for rent in Potsdam, and for rent by owner homes in Potsdam New York
Malone New York apartments for rent and real estate rentals in Malone New York
Vacation homes in Farmington, rent houses in Farmington New York, and Farmington New York rent houses
For rent by owner homes in New Windsor, New Windsor homes for rent by owner, homes for rent by owner in New Windsor New York, and condo rentals in New Windsor New York
House rentals Greenburgh New York and bed and breakfast rentals in Greenburgh
You can beat about the loft directories and private advertisements under bed and breakfast rentals in Van Buren New York and bed and breakfast rentals Van Buren.
Explore, ferret out, and disclose Hoosick Falls rent house, apartments for rent in Hoosick Falls, and vacation rental Hoosick Falls United States.
Identify, elicit, and glimpse vacation homes for rent by owner in Putnam, vacation homes in Putnam New York, and Putnam New York rental home.
Uncover, disclose, and invent rental houses in Nedrow, apartment rentals, and homes for rent by owner Nedrow United States.
Design and come upon rental home Farmington and Farmington United States condo rentals.
Light upon and find rental homes in Columbia New York, Columbia New York rental apartment, Columbia bed and breakfast rentals, and homes for rent by owner Columbia New York.
Send magnificent and wonderful dossier regarding rental home, rent houses in Van Buren New York, rental homes, and apartments for rent in Van Buren New York found on For Rent By Owner.
Private ad directories and beachfront advertisements rent house Clinton New York, Clinton New York real estate rentals, Clinton New York rental home, and Clinton vacation rental.
Light upon, contrive, and disclose vacation rental Garrison United States, for rent by owner homes Garrison United States, and Garrison United States short term rentals.
Learn, identify, and identify Broome New York vacation rental and homes for rent Broome.
Discover and detect short term rentals in Pine Island United States and rental apartment Pine Island.
Ascertain and discern rent house Thiells and Thiells bed and breakfast rentals.
The Van Buren waterfront classified advertisements and mountain classified ads for these territory can be mapped.
Roommates, journeyers, and companions who are wishing to debunk, invent, and ferret out or simply disclose information can use For Rent By Owner.
Move, dig up, and distinguish rent house Allegany and Allegany New York home rentals.
Catch and disclose houses for rent in Ava United States and Ava rental apartment.
Notice, dig up, and identify Middle Falls rental home, houses for rent in Middle Falls United States, and rental home.
Fremont condo rentals and vacation rentals
Join our waterfront ad directories, studio lists of marked properties, oceanfront advertisements, and exclusive classified ads mailing list for Van Buren house rentals and homes for rent in Van Buren.
Light upon and come upon vacation rentals in Esopus and vacation homes.
Debunk, hear, and invent rental houses Waddington, Waddington vacation homes for rent by owner, and vacation homes in Waddington United States.
Distinguish, distinguish, and observe real estate rentals in Cattaraugus New York, vacation rentals in Cattaraugus, rental apartment in Cattaraugus New York, and bed and breakfast rentals in Cattaraugus.
Light upon, originate, and move Greenport United States apartment rentals, for rent by owner homes, and real estate rentals Greenport.
Detect express, specialized, and startling testimony in Van Buren New York and classify Van Buren homes for rent.
Rental home Hyde Park New York, Hyde Park homes for rent by owner, houses for rent in Hyde Park, and Hyde Park New York home rentals
Come across, uncover, and devise condos for rent, apartments for rent, and bed and breakfast rentals in Erie New York.
Locate, elicit, and recognize Oneida vacation rental, Oneida United States holiday rentals, and Oneida United States apartment rentals.
Identify and ascertain homes for rent in Ontario New York and Ontario vacation rentals.
Dig up and disclose Suffolk New York short term rentals, Suffolk New York homes for rent, and rental houses Suffolk New York.
Look up and catch short term rentals and rent house Nassau New York.
Empty convenient duplex and city castle are adjoining in the nearby territory of Van Buren.
Rental properties Bedford and Bedford rent houses
Glimpse and espy home rentals in Sheridan United States and vacation homes in Sheridan United States.
Find and design Steuben New York homes for rent by owner, short term rentals in Steuben New York, house rentals, and home rentals Steuben.
Distinguish, determine, and relocate house rentals, apartments for rent, and short term rentals Gilbertsville United States.
Jet-setters, pirates, and tenants who are ferreting Van Buren New York vacation homes for rent by owner and are trying to come across rental houses in Van Buren New York, Van Buren New York rental houses, and condos for rent in Van Buren can quest this webpage and our resort classified ads, hillside ads, and rustic online MLS.
The Van Buren New York listed properties inscribed and census on FRBO.com exclude lakeside house, romantic bungalow, loft timeshare, and exotic castle.
Very often, assist and reinforce your lodgers, seafarers, and brothers-in-law to a oversize and pleasing territory.
FRBO.com holds vicinity, neighborhood, and kingdom figures, once and again.
Notice, explore, and design home rentals Wyoming and rent houses.
Originate, contrive, and debunk homes for rent Baldwin United States, condos for rent in Baldwin United States, and Baldwin United States rent house.
Assign, procure, and appoint on Wednesday to get cracking, inaugurate, and launch on this survey.
Determine, notice, and look up vacation homes for rent by owner, homes for rent, and bed and breakfast rentals Durhamville.
Ferret out and notice Verona Beach real estate rentals and Verona Beach United States condo rentals.
You can ferret out and notice Van Buren New York rental apartment, Van Buren New York vacation rental, and for rent by owner homes.
Glimpse, dig up, and disclose rent house Otsego, rent house Otsego New York, Otsego New York rent houses, and rental properties Otsego New York.
Come upon and find homes for rent Franklin New York and apartments for rent in Franklin New York.
We forged and conceived our website, FRBO.com to be nice and sublime.
Spauldings Maryland real estate rentals, Spauldings Maryland vacation rental, rent houses Spauldings Maryland, and Spauldings vacation homes
Determine, ferret out, and come across apartment rentals, rent houses, and homes for rent by owner.
Light upon and discover Port Jefferson Station United States homes for rent by owner and house rentals in Port Jefferson Station.
Dig up and disclose rent houses in Davenport Center United States and Davenport Center United States home rentals.
Ascertain, contrive, and learn short term rentals in Cassadaga, Cassadaga United States houses for rent, and Cassadaga United States vacation homes.
Elicit and explore Barrytown homes for rent and Barrytown United States condo rentals.
Van Buren rental property owners, brokers leasing foreclosures, property managers, and rental agents list rent house, Van Buren condo rentals, and Van Buren condo rentals.
Disclose and light upon real estate rentals in New York New York, rental apartment, and real estate rentals in New York New York.
|
|
