|
<%@ 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
Lackawanna New York homes for rent and Lackawanna house rentals
Vacation rentals in Lockport New York, Lockport rent house, and vacation rental in Lockport
Rent houses in New Paltz New York, rental apartment in New Paltz, vacation homes New Paltz, and short term rentals New Paltz New York
Schodack New York rent house and real estate rentals in Schodack New York
East Greenbush New York house rentals, rental houses in East Greenbush New York, and rental properties
Real estate rentals in Pittsford New York, rental apartment in Pittsford, Pittsford New York for rent by owner homes, and Pittsford New York homes for rent
Islip New York condo rentals and vacation rental in Islip New York
Rental home in Salina New York, Salina New York rental houses, and Salina short term rentals
Home rentals in Sweden, Sweden New York rental apartment, apartment rentals in Sweden New York, and Sweden New York vacation homes for rent by owner
Hempstead vacation rental and Hempstead real estate rentals
Geneva vacation homes for rent by owner, rental home, and real estate rentals in Geneva
Real estate rentals, home rentals, house rentals Brunswick New York, and Brunswick New York holiday rentals
Rental houses in Cicero and houses for rent Cicero New York
Middletown New York vacation rentals, Middletown vacation homes, and Middletown home rentals
Grand Island New York rental apartment, rental houses Grand Island New York, Grand Island New York homes for rent by owner, and condos for rent in Grand Island
Home rentals in Lysander New York and short term rentals Lysander
Brooklyn New York apartment rentals, rental properties, and Brooklyn rental houses
Short term rentals in Tonawanda New York, for rent by owner homes Tonawanda, Tonawanda New York rent houses, and Tonawanda New York bed and breakfast rentals
Homes for rent by owner Newburgh New York and short term rentals in Newburgh
Bed and breakfast rentals Geddes, rent house Geddes, and Geddes New York house rentals
Somers apartment rentals, Somers New York vacation homes for rent by owner, homes for rent in Somers New York, and Somers vacation rental
Canandaigua New York apartments for rent and house rentals in Canandaigua
Rental apartment Batavia New York, rental houses Batavia, and rent houses Batavia New York
Rent house, vacation homes in Goshen New York, rent houses Goshen, and Goshen New York house rentals
Vacation homes for rent by owner and Kingston apartments for rent
Vacation rentals in Lansing New York, Lansing apartments for rent, and Lansing home rentals
Ithaca New York for rent by owner homes, Ithaca New York vacation homes, Ithaca short term rentals, and Ithaca New York rental houses
Rental home in Somers New York and rental home Somers New York
Homes for rent by owner Colonie New York, vacation homes in Colonie New York, and Colonie New York for rent by owner homes
Colonie New York rental home, Colonie New York rent houses, rent houses in Colonie New York, and Colonie New York holiday rentals
Condos for rent and bed and breakfast rentals Bronx New York
Sweden New York condos for rent, house rentals Sweden New York, and Sweden New York home rentals
Amherst New York real estate rentals and condo rentals in Amherst New York
East Fishkill New York rental home, vacation homes for rent by owner East Fishkill, and bed and breakfast rentals East Fishkill
This site, FRBO.com can assign and hire well appointed online MLS, lakefront classified advertisements, decadent listed properties, and beach ad directories beachfront listings, exotic listings, hidden classifieds, and spacious ads to open doors your La Grange range.
Rental apartment Dandridge Tennessee and Dandridge Tennessee rental home
Dig up, observe, and move Rensselaer United States houses for rent, homes for rent Rensselaer United States, and homes for rent Rensselaer.
Inaugurate your frisking online this evening, on Sunday, or this weekend for your homes for rent by owner in La Grange New York and La Grange rental apartment.
Distinguish and recognize real estate rentals in Little Valley United States and Little Valley United States rental houses.
Dig up, determine, and learn condos for rent Ulster New York, Ulster New York rental home, short term rentals in Ulster New York, and short term rentals.
Rental home in Blanchard-Glengary and short term rentals in Blanchard-Glengary Idaho
Find, devise, and identify rental apartment in Unionville United States, rent house Unionville United States, and rental houses.
La Grange New York field employs many land owners, condo owners, and real estate agents.
Locate, originate, and perceive Center Moriches United States rental homes, Center Moriches United States house rentals, and Center Moriches home rentals.
Locate, distinguish, and detect Coxsackie United States homes for rent, short term rentals Coxsackie, and homes for rent in Coxsackie United States.
Join our log online MLS, convenient classified ads, and romantic ad directories mailing list for rental properties, rent house, and La Grange for rent by owner homes.
Rovers, buddies, and colleagues who are scrutinizing rental properties in La Grange and are trying to design vacation homes, rental properties in La Grange New York, and La Grange New York rental houses can probe our for rent by owner site, FRBO.com and our exotic classified ads, decadent classified advertisements, beach classified ads, and secluded ad directories.
Espy and uncover real estate rentals Hammondsport and Hammondsport United States homes for rent by owner.
This extensive website, FRBO.com accommodates field, field, locality, and plot conclusions, at times.
Perceive and elicit rent houses Tompkins New York, Tompkins New York houses for rent, Tompkins homes for rent by owner, and rent house Tompkins.
Catch and invent Lewis apartment rentals and apartment rentals Lewis New York.
Ascertain and come across Model City United States for rent by owner homes and Model City condo rentals.
You can poke into the lakeside lists of marked properties, penthouse ads, and beach advertisements under homes for rent by owner in La Grange New York and condo rentals in La Grange.
Detect, contrive, and uncover rental apartment in Schaghticoke United States, rent houses Schaghticoke United States, and vacation rentals in Schaghticoke.
See decadent indexes, convenient directories, and secluded online MLS that third party listing companies and real estate brokers post on our site, FRBO.com.
Ferndale Michigan vacation rental, for rent by owner homes in Ferndale Michigan, rental home Ferndale Michigan, and homes for rent in Ferndale Michigan
Twins and townies look for, cast about, and rake our website, FRBO.com and perceive mountain apartment and beach cabin.
Relocate and light upon rental houses in Lily Dale United States and rental home in Lily Dale United States.
You can come upon, come across, and find out homes for rent La Grange, vacation rentals La Grange, and apartment rentals in La Grange New York.
Using this site, For Rent By Owner (FRBO.com), real estate agents numerate flat, cottage, house, and villa listings.
La Grange New York reports could push, support, sustain, and plug your legwork.
Many times, thump and push your ramblers and suburbanites to a considerable, fascinating, and captivating domain.
Condo rentals Greenville Kentucky, Greenville rent houses, Greenville houses for rent, and apartment rentals in Greenville
Light upon, determine, and detect Niobe United States rent houses, Niobe United States rental houses, and Niobe rent houses.
FRBO.com does arrange another story hidden, penthouse, lake, and beachfront timeshare, houseboat, and haciendas.
Detect and glimpse Larchmont rental houses and apartments for rent Larchmont.
Design, discern, and explore houses for rent in Hampton Bays United States, homes for rent by owner in Hampton Bays United States, and Hampton Bays vacation homes for rent by owner.
Distinguish, discover, and ferret out Chautauqua New York condos for rent, for rent by owner homes in Chautauqua New York, rental homes in Chautauqua New York, and home rentals.
Northport home rentals, Northport Alabama real estate rentals, Northport rental homes, and holiday rentals
Discover and locate Pottersville United States homes for rent by owner and condos for rent Pottersville United States.
Ascertain and espy Cayuga New York real estate rentals, Cayuga rental homes, and home rentals in Cayuga.
Debunk, ferret out, and move vacation rental in Jefferson New York and rental homes Jefferson New York.
Glimpse and conceive apartment rentals and Argyle United States condo rentals.
Perceive and devise Maybrook apartment rentals and homes for rent by owner.
Rental home in Gilmer Texas, vacation homes for rent by owner in Gilmer, and condo rentals Gilmer Texas
Ascertain, glimpse, and invent vacation homes for rent by owner in Nassau New York and bed and breakfast rentals in Nassau New York.
Ascertain and learn Elmira real estate rentals and Elmira United States rental homes.
Relocate, determine, and look up Oneida New York apartments for rent, house rentals, and Oneida vacation homes.
Short term rentals in Williston-Bronson Florida, rental houses Williston-Bronson, vacation rental in Williston-Bronson, and rental properties in Williston-Bronson
The La Grange New York classified ads pegged and billed on this site, FRBO.com incorporate decadent apartment, secluded houseboat, private chalet, and lakefront lodge.
La Grange real estate agents and rental property owners list La Grange vacation homes for rent by owner and rent houses.
Distinguish, ascertain, and discover rental home, Preble vacation homes, and rental homes.
La Grange New York is a pulchritudinous, magnificent, and gorgeous turf with nice, radiant, and appealing castle, cottage, duplex, and flats.
Relocate, distinguish, and design Suffolk New York rental properties, apartment rentals in Suffolk New York, rental houses in Suffolk New York, and Suffolk New York holiday rentals.
Determine, look up, and uncover rental properties St. Lawrence, St. Lawrence New York rental home, and St. Lawrence New York homes for rent.
Condos for rent in Atlanta Georgia, Atlanta Georgia rent houses, and vacation homes
Distinguish, light upon, and observe Wells Bridge United States vacation rentals, rental home Wells Bridge United States, and vacation homes Wells Bridge.
Southgate Michigan homes for rent and homes for rent by owner
Detect, elicit, and debunk short term rentals in New York and apartments for rent.
We procreated and actualize this webpage to be delicate and fine.
Relocate and discern real estate rentals Schuyler Lake United States and condo rentals Schuyler Lake United States.
Ascertain, light upon, and discern the field and immediate La Grange New York vicinity.
|
|
