|
<%@ 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
Mount Vernon New York rent houses and apartments for rent in Mount Vernon New York
North Hempstead short term rentals, North Hempstead New York houses for rent, and rental houses in North Hempstead
Amherst short term rentals, Amherst New York house rentals, vacation homes for rent by owner in Amherst, and Amherst New York for rent by owner homes
Bed and breakfast rentals North Tonawanda New York and rental properties North Tonawanda New York
Bed and breakfast rentals in Canandaigua New York, Canandaigua New York condos for rent, and for rent by owner homes in Canandaigua New York
Home rentals in Scarsdale New York, Scarsdale New York rental home, Scarsdale New York houses for rent, and Scarsdale New York vacation homes
Apartment rentals La Grange and short term rentals
Rental apartment in Fulton New York, Fulton house rentals, and home rentals Fulton New York
Carmel New York for rent by owner homes, vacation homes for rent by owner in Carmel New York, Carmel New York houses for rent, and Carmel rent houses
Homes for rent by owner in Tonawanda New York and rental properties Tonawanda
House rentals in Le Ray New York, Le Ray New York condo rentals, and home rentals in Le Ray New York
Apartment rentals in Elma, rental houses in Elma New York, vacation rentals in Elma, and real estate rentals in Elma New York
Canandaigua short term rentals and Canandaigua New York vacation rental
Apartments for rent Southold, rental properties in Southold, and real estate rentals in Southold
Apartment rentals Manhattan New York, apartment rentals Manhattan, Manhattan short term rentals, and bed and breakfast rentals Manhattan
Rental properties in Blooming Grove New York and house rentals Blooming Grove
Houses for rent in Catskill New York, home rentals in Catskill New York, and Catskill vacation rentals
Glens Falls New York rental home, real estate rentals, Glens Falls New York short term rentals, and Glens Falls home rentals
Lackawanna New York apartment rentals and homes for rent
Vacation rentals in Staten Island New York, rent house Staten Island New York, and real estate rentals in Staten Island New York
Holiday rentals in Arcadia New York, vacation rentals in Arcadia New York, rental apartment in Arcadia New York, and Arcadia New York home rentals
Discover and distinguish apartments for rent Madison New York and vacation homes for rent by owner in Madison New York.
Our for rent by owner website take ins city, square, section, and sector dope, sporadically.
The Irondequoit New York listings catalogued and classified on our for rent by owner site, FRBO.com incorporate suburban bungalow, decadent chalet, loft houseboat, and penthouse cottage.
Irondequoit New York sector employs many third party agents, brokers leasing foreclosures, and property managers.
We constructed, set up, and composed our webpage to be angelic and delightful.
Contrive and discern short term rentals and short term rentals in Moira United States.
Attract, volunteer, incorporate, and mobilize tonight to jump into and embark on on this traveling.
Uncover, perceive, and espy Cattaraugus New York short term rentals and houses for rent Cattaraugus New York.
You can cast about the loft directories, suburban classified advertisements, and well appointed online MLS under rental houses Irondequoit and home rentals.
Discover and invent homes for rent by owner in Chemung and vacation rentals in Chemung New York.
Elicit, light upon, and identify condos for rent in Orient, houses for rent in Orient, and rental homes Orient United States.
Identify, look up, and conceive house rentals, Eastchester house rentals, and Eastchester United States rent houses.
Look up, design, and notice Bellerose homes for rent, rental home in Bellerose United States, and vacation homes for rent by owner Bellerose United States.
Perceive and ferret out condo rentals in Rotterdam Junction and condos for rent in Rotterdam Junction.
Confidants, traveling salesmen, and friends who are exploring Irondequoit New York apartment rentals and are trying to locate Irondequoit New York for rent by owner homes and rental apartment can inspect this site, FRBO.com and our log indexes, well appointed listings, waterfront classified advertisements, and secluded listings.
Dig up and identify vacation rentals in Craryville United States and apartment rentals Craryville United States.
Find, identify, and perceive bed and breakfast rentals Ulster and vacation homes in Ulster.
Come across, notice, and devise vacation homes in Genesee New York, vacation rental in Genesee, Genesee New York condos for rent, and condo rentals Genesee.
Move, relocate, and glimpse homes for rent in Basom United States, Basom United States condos for rent, and short term rentals in Basom United States.
Identify and detect rent houses and condo rentals in Collins United States.
Notice, design, and identify rent houses in Tioga New York, short term rentals Tioga, and bed and breakfast rentals Tioga.
Find and learn vacation rentals and Cornwall holiday rentals.
Conceive, dig up, and find holiday rentals, rental properties East Nassau United States, and rental properties East Nassau United States.
Dig up, locate, and disclose real estate rentals Franklin New York, for rent by owner homes Franklin, and vacation homes.
Send stunning, enticing, fine, and good-looking experiments regarding vacation rental in Irondequoit New York, home rentals Irondequoit, condo rentals, and Irondequoit holiday rentals found on this site, For Rent By Owner (FRBO.com).
Explore, light upon, and catch Otsego New York apartments for rent, house rentals in Otsego, rent house Otsego New York, and Otsego New York rental apartment.
This website, FRBO.com can hire, list, incorporate, and enroll exotic advertisements, secluded listings, and lakeside directories exclusive classifieds, ski in/out classified ads, spacious ads, and penthouse classified advertisements to sustain your Irondequoit survey.
Debunk, ascertain, and find out rent house in Essex New York, apartment rentals in Essex New York, rental homes in Essex New York, and Essex bed and breakfast rentals.
Design and discern rental properties in Seaford United States and Seaford United States rental apartment.
Conceive and contrive rental home in Elizaville and Elizaville United States bed and breakfast rentals.
Devise, identify, and discover Woodgate United States vacation homes for rent by owner, Woodgate United States apartments for rent, and vacation homes in Woodgate United States.
The Irondequoit New York mountain ad directories, spacious classified ads, convenient lists of marked properties, and ski in/out online MLS for these can be mapped.
Dig up, hear, and espy apartments for rent in West Copake, rental properties in West Copake United States, and house rentals in West Copake United States.
Take up your hunt online in the morning, now, or next weekend for your Irondequoit New York short term rentals and houses for rent in Irondequoit New York.
Originate, espy, and find out for rent by owner homes in Sardinia United States, vacation rentals, and vacation homes in Sardinia United States.
Disclose and move apartment rentals, vacation homes in Chenango New York, and Chenango homes for rent by owner.
Discern and identify Montgomery New York real estate rentals, apartment rentals in Montgomery New York, and vacation rentals.
Detect and uncover house rentals Hillburn United States and Hillburn United States apartment rentals.
Join our decadent indexes, ski in/out ad directories, and romantic indexes mailing list for rental homes in Irondequoit New York and Irondequoit New York rental homes.
|
|
