|
<%@ 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
Home rentals Schodack New York and rent houses in Schodack
Homes for rent by owner in Chester New York, vacation rental in Chester New York, and Chester apartments for rent
Vacation rentals in Ithaca New York, rental apartment in Ithaca, apartments for rent Ithaca New York, and rental apartment in Ithaca New York
Condos for rent in Corning and rental home in Corning New York
Condo rentals in Middletown New York, condo rentals in Middletown, and short term rentals in Middletown New York
Short term rentals Mount Vernon, vacation rental in Mount Vernon, vacation homes for rent by owner Mount Vernon New York, and Mount Vernon rental home
Houses for rent and bed and breakfast rentals Ramapo
Homes for rent, for rent by owner homes in Poughkeepsie New York, and home rentals in Poughkeepsie New York
Condo rentals in New Paltz New York, vacation homes for rent by owner in New Paltz, home rentals in New Paltz, and New Paltz vacation homes for rent by owner
Canandaigua New York condo rentals and condo rentals in Canandaigua New York
Condo rentals Buffalo New York, rental home, and homes for rent by owner in Buffalo
Bed and breakfast rentals in Ogdensburg, Ogdensburg New York house rentals, bed and breakfast rentals in Ogdensburg New York, and Ogdensburg New York holiday rentals
Homes for rent by owner in Oyster Bay New York and Oyster Bay New York vacation homes for rent by owner
Oswego New York rental apartment, holiday rentals in Oswego, and Oswego rental houses
Holiday rentals Rotterdam, for rent by owner homes Rotterdam, Rotterdam New York for rent by owner homes, and rental houses in Rotterdam New York
Rental apartment New Hartford New York and New Hartford vacation homes for rent by owner
Short term rentals in Brookhaven New York, vacation rentals in Brookhaven, and Brookhaven for rent by owner homes
Holiday rentals in Haverstraw New York, Haverstraw rent house, Haverstraw New York vacation homes, and vacation rental Haverstraw
Homes for rent by owner in Colonie New York and for rent by owner homes
New Windsor New York condos for rent, New Windsor New York vacation homes, and rent houses in New Windsor
Clarence condos for rent, Clarence New York rental properties, short term rentals in Clarence New York, and condo rentals Clarence
Real estate rentals in Watertown and Watertown New York condo rentals
Rental home, Hamburg rental homes, and Hamburg homes for rent by owner
Hempstead home rentals, real estate rentals in Hempstead, apartments for rent in Hempstead New York, and houses for rent in Hempstead
Rental apartment Grand Island New York and vacation rental Grand Island
House rentals in Glen Cove New York, Glen Cove New York homes for rent, and Glen Cove New York vacation rental
Bed and breakfast rentals Monroe New York, Monroe rental homes, homes for rent by owner Monroe, and bed and breakfast rentals
Trippers and colleagues who are wishing to glimpse, discern, and explore or simply ferret out information can use this website, FRBO.com.
Discover, find out, and ferret out Glen Cove United States short term rentals, Glen Cove rent houses, and house rentals in Glen Cove.
Using our site, FRBO.com, town home owners book house, apartment, and hacienda listings.
Infrequently, work for and ballyhoo your displaced persons and confreres to a really now, stunning, commodious, and colossal county.
Conceive, ferret out, and identify real estate rentals Monticello United States, holiday rentals in Monticello United States, and condos for rent in Monticello United States.
Debunk, locate, and find rent houses Cortland, Cortland New York rental apartment, real estate rentals Cortland New York, and Cortland New York rental apartment.
Come upon, devise, and locate house rentals, homes for rent by owner in Orange New York, and vacation homes for rent by owner Orange New York.
Perceive, discern, and detect rental homes in Lorraine United States, Lorraine home rentals, and real estate rentals in Lorraine United States.
Recognize and conceive condo rentals in Cayuga, Cayuga New York condo rentals, and vacation rental Cayuga.
New Windsor New York knowledge could support and support your wild-goose chase.
Join our ski in/out ad directories, studio classified advertisements, and suburban ad directories mailing list for rent house in New Windsor and homes for rent.
New Windsor New York is a gorgeous and pulchritudinous block with graceful, divine, ideal, and pulchritudinous condominium, farmhouse, vacation home, and timeshares.
New Windsor property brokers, third party agents, and third party listing companies list apartment rentals New Windsor New York, vacation homes for rent by owner in New Windsor New York, and houses for rent in New Windsor.
Debunk and distinguish rent house in Breezy Point United States and for rent by owner homes.
Register, enter, and list this evening to kick off and tear into on this venture.
Distinguish, ascertain, and determine homes for rent by owner in Arkport United States, Arkport United States apartments for rent, and apartment rentals.
Disclose, dig up, and find out holiday rentals in Clinton New York and Clinton New York rental houses.
Come upon and catch Richmond New York houses for rent and holiday rentals Richmond.
Waterfront classified ads and loft ad directories rental homes Suffolk, rent house in Suffolk, rental houses in Suffolk New York, and rent houses.
Contrive and determine Cortland condo rentals and homes for rent by owner in Cortland.
Ascertain and find condos for rent in Islandia United States and apartments for rent.
Identify, distinguish, and locate for rent by owner homes, rental properties in Saratoga New York, and vacation rental in Saratoga.
Find out, relocate, and debunk houses for rent Chemung and homes for rent.
Hear and identify home rentals in Roslyn United States and Roslyn United States homes for rent.
Light upon, explore, and learn rental homes in Ontario New York and Ontario New York vacation homes for rent by owner.
The New Windsor indexes numerated and catalogued on our website, FRBO.com accommodate oceanfront ranch and lakefront houseboat.
Launch your pursual online this evening, now, in the next few days, or tonight for your houses for rent, house rentals, and holiday rentals.
Catch, ascertain, and come upon homes for rent in Cold Spring United States, condo rentals, and rental properties in Cold Spring.
Detect and recognize house rentals Orange New York, Orange New York bed and breakfast rentals, rent houses in Orange, and Orange New York condos for rent.
Light upon, observe, and recognize rental home, Vails Gate United States rent houses, and Vails Gate home rentals.
Originate and explore vacation rentals Roosevelt and Roosevelt homes for rent by owner.
Determine and conceive rent house Lake View and rent house in Lake View United States.
Recently vacated spacious chalet, mountain hacienda, lakefront houseboat, and waterfront timeshare are near-at-hand in the not far away turf of New Windsor New York.
FRBO.Com, For Rent By Owner, can take on and procure decadent ads, lake indexes, and loft ad directories ski in/out lists of marked properties and spacious ad directories to sustain your New Windsor New York route.
Come across, contrive, and ferret out Rexford rental properties, bed and breakfast rentals, and rental homes Rexford.
Our for rent by owner website does exclude novel suburban, well appointed, and secluded apartment and lodges.
We sired and occasioned our for rent by owner site, FRBO.com to be comely and classy.
Rental homes in Indianola Iowa, rental houses Indianola Iowa, and Indianola Iowa holiday rentals
Originate and hear rental apartment Schuyler, vacation rental in Schuyler, vacation rental, and houses for rent in Schuyler.
See exotic advertisements and lakeside classifieds that property owners and home owners post on our for rent by owner site, FRBO.com.
Disclose, move, and find Jefferson New York rental houses, condos for rent in Jefferson, rental houses Jefferson New York, and house rentals Jefferson.
Holiday rentals and Mount Washington Kentucky houses for rent
Notice and come upon Chautauqua New York rental houses, condo rentals Chautauqua New York, and condo rentals Chautauqua.
Distinguish, come across, and come upon apartments for rent in Otsego New York, Otsego New York rental houses, Otsego vacation rentals, and homes for rent.
New Windsor New York neighborhood employs many rental owners and brokers leasing foreclosures.
|
|
