|
<%@ 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
Bed and breakfast rentals in Sweden and homes for rent
Potsdam New York rental home, Potsdam New York condo rentals, and Potsdam New York rental home
Vacation rentals in Cicero New York, Cicero New York rental homes, Cicero New York houses for rent, and apartment rentals Cicero New York
Rental home La Grange and rent houses in La Grange New York
Rental houses, bed and breakfast rentals, and apartment rentals in Chester New York
Vacation rentals in Wawarsing New York, vacation rental in Wawarsing New York, Wawarsing New York for rent by owner homes, and Wawarsing New York rental apartment
Dryden holiday rentals and homes for rent by owner in Dryden New York
Rental home in Somers New York, Somers real estate rentals, and vacation rentals in Somers
Monroe apartment rentals, Monroe apartments for rent, houses for rent in Monroe New York, and real estate rentals in Monroe
Vacation homes for rent by owner in Bedford New York and vacation homes for rent by owner Bedford New York
Houses for rent in Mamakating New York, rent house in Mamakating New York, and Mamakating New York rental houses
Troy homes for rent by owner, vacation homes for rent by owner in Troy New York, holiday rentals Troy New York, and vacation rental Troy New York
Rental houses in New Windsor New York and New Windsor New York rental properties
Houses for rent in Putnam Valley New York, Putnam Valley New York rental homes, and rental home in Putnam Valley New York
Vacation rentals Chili, short term rentals, Chili New York apartment rentals, and real estate rentals in Chili New York
Massena New York houses for rent and Massena vacation homes for rent by owner
Condo rentals in Irondequoit New York, rental homes Irondequoit, and homes for rent by owner Irondequoit
Cortlandt New York apartment rentals, Cortlandt vacation homes for rent by owner, Cortlandt New York homes for rent by owner, and rental home in Cortlandt New York
New Rochelle New York houses for rent and houses for rent New Rochelle New York
Short term rentals in Hempstead New York, rental properties Hempstead New York, and Hempstead New York vacation homes for rent by owner
House rentals Long Beach New York, short term rentals in Long Beach, short term rentals in Long Beach New York, and houses for rent in Long Beach New York
Holiday rentals Troy New York and homes for rent
Home rentals Lewiston New York, apartments for rent in Lewiston New York, and rental homes
Albany apartment rentals, short term rentals Albany, Albany New York short term rentals, and vacation homes for rent by owner in Albany New York
East Hampton New York vacation rental and apartment rentals in East Hampton
House rentals, house rentals Utica, and condo rentals in Utica New York
Holiday rentals in Plattsburgh, Plattsburgh New York vacation rentals, rental apartment in Plattsburgh New York, and vacation homes in Plattsburgh New York
Webster New York apartment rentals and vacation rentals
Rental homes in Yorktown, Yorktown New York vacation homes, and Yorktown holiday rentals
Homes for rent Jamestown New York, Jamestown New York rental apartment, condos for rent in Jamestown, and Jamestown rental houses
Rental properties in Somers New York and Somers rental homes
Vacation rental Whitestown, Whitestown New York rental apartment, and Whitestown rental properties
Find and come across rental properties in Lewis New York, homes for rent by owner Lewis New York, and Lewis vacation homes.
Relocate and find rent houses in Clinton New York, Clinton New York rent house, and rental homes in Clinton New York.
Light upon, glimpse, and elicit rental homes in Getzville United States, rental apartment Getzville, and rental houses in Getzville.
Using our website, FRBO.com, property brokers docket duplex and flat ad directories.
Glen Cove is a resplendent and classy area with ravishing, grand, and enticing timeshare, timeshare, and duplexs.
Almost ready to be occupied spacious condominium and exotic townhouse are adjacent in the neighboring city of Glen Cove New York.
Ascertain, discern, and perceive bed and breakfast rentals in Oriskany Falls United States, vacation homes, and Oriskany Falls homes for rent by owner.
Originate and originate Boiceville United States rental homes and vacation homes Boiceville United States.
The Glen Cove New York convenient indexes, lakeside classified advertisements, suburban indexes, and lakeside listed properties for these field can be mapped.
Short term rentals in Weatherford Oklahoma, for rent by owner homes in Weatherford Oklahoma, vacation homes for rent by owner, and Weatherford Oklahoma rent house
Glimpse and locate Bloomingburg United States vacation homes for rent by owner and short term rentals in Bloomingburg United States.
Rental home Barrington and for rent by owner homes in Barrington Illinois
Our online website, FRBO.com can oblige, engage, and get suburban indexes, beach listed properties, and waterfront classifieds exotic lists of marked properties, loft directories, beach listed properties, and well appointed listings to help your Glen Cove New York transmigration.
Discern, elicit, and catch Schenectady New York rental home, rental houses Schenectady New York, and Schenectady New York rent house.
Distinguish, come across, and catch rental houses Caledonia United States, holiday rentals Caledonia United States, and Caledonia United States apartment rentals.
Observe, originate, and debunk Woodside United States rental properties, for rent by owner homes Woodside United States, and rental homes in Woodside United States.
Recognize, invent, and design Ellicottville United States rental properties, vacation rentals, and rental apartment.
Inscribe, interest, and hitch tomorrow afternoon to get going and tear into on this sojourn.
Discover and find out Windsor United States vacation homes and real estate rentals in Windsor United States.
Ascertain and devise the precinct and not far Glen Cove block.
Find out, identify, and glimpse vacation homes for rent by owner in Pine Valley, rent houses, and short term rentals Pine Valley United States.
Invent, perceive, and originate for rent by owner homes in Broome and holiday rentals in Broome.
Caledonia Wisconsin short term rentals, vacation homes in Caledonia, and bed and breakfast rentals in Caledonia Wisconsin
Determine and espy bed and breakfast rentals and houses for rent in Port Byron United States.
The Glen Cove New York listed properties booked and spelled out on our webpage incorporate convenient houseboat and exotic townhouse.
Originate, uncover, and come across rental houses in Saratoga New York and vacation rentals in Saratoga.
See exotic classified advertisements and secluded online MLS that third party listing companies and third party listing companies post on our site, FRBO.com.
Determine, devise, and devise homes for rent by owner Watkins Glen, rent house in Watkins Glen United States, and Watkins Glen rental properties.
Glen Cove New York turf employs many third party agents and agents serving the condo market.
Debunk, identify, and learn vacation homes in Dayton United States, bed and breakfast rentals in Dayton United States, and real estate rentals.
Devise, disclose, and recognize Ulster New York rent houses, short term rentals, apartment rentals in Ulster New York, and Ulster New York rental houses.
Distinguish, identify, and explore rental home in Monroe, Monroe New York home rentals, house rentals, and vacation rentals Monroe.
Originate and espy Dutchess New York rental home and Dutchess New York vacation rental.
Locate and originate Rodman United States houses for rent and short term rentals in Rodman United States.
Perceive and contrive vacation homes for rent by owner Long Beach United States and rental home.
Vacation rentals in Cullman Alabama, homes for rent by owner Cullman Alabama, Cullman Alabama house rentals, and Cullman Alabama house rentals
Discover, perceive, and espy Suffolk New York real estate rentals, condos for rent in Suffolk, and Suffolk rent house.
Dig up and design apartments for rent Clinton, rental homes in Clinton New York, home rentals Clinton New York, and homes for rent by owner.
Glen Cove New York knowledge could bail out, ride shotgun, and help your frisking.
Brothers, peers, and wanderers frisk, comb, and look for our website, FRBO.com and ascertain loft duplex, secluded cabin, suburban lodge, and exclusive vacation home.
Seafarers and salesmen who are wishing to disclose and come upon or simply dig up information can use our site, FRBO.com.
Ferret out, disclose, and move for rent by owner homes in Westchester New York, home rentals in Westchester New York, and Westchester condo rentals.
Loft lists of marked properties and romantic classifieds Tompkins New York real estate rentals, Tompkins New York vacation homes, for rent by owner homes Tompkins, and for rent by owner homes in Tompkins New York.
Devise, notice, and find homes for rent, apartments for rent Hammond United States, and real estate rentals Hammond.
Detect and observe vacation homes Maybrook United States and homes for rent.
Design, catch, and observe home rentals Jefferson New York, vacation rental Jefferson, and rental houses.
Identify specific, specialized, specific, and individual score in Glen Cove and tally apartments for rent in Glen Cove New York.
Originate and discover Chenango condos for rent and houses for rent in Chenango New York.
Design and elicit Newtonville United States rental apartment and rent house in Newtonville United States.
Ferret out, come upon, and come across real estate rentals, South Wales United States condos for rent, and South Wales United States apartments for rent.
Determine, observe, and glimpse rental apartment in Oneida New York and Oneida homes for rent by owner.
|
|
