|
<%@ 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 Jersey Rental Links
For rent by owner homes in Millburn New Jersey and rent house in Millburn
Bound Brook New Jersey for rent by owner homes, Bound Brook rental home, and Bound Brook New Jersey for rent by owner homes
Homes for rent by owner Bernards New Jersey, houses for rent in Bernards, vacation homes in Bernards New Jersey, and Bernards New Jersey apartments for rent
Paterson house rentals and rental properties
Rental homes in Chatham New Jersey, homes for rent by owner Chatham, and Chatham New Jersey homes for rent by owner
Fort Lee New Jersey home rentals, rental houses in Fort Lee, Fort Lee condos for rent, and Fort Lee New Jersey apartments for rent
Vacation homes in Hazlet and short term rentals in Hazlet New Jersey
Newark homes for rent by owner, Newark short term rentals, and rental homes Newark New Jersey
Manville New Jersey rental apartment, home rentals Manville, house rentals Manville, and house rentals Manville
Lincoln Park New Jersey vacation rental and apartments for rent in Lincoln Park New Jersey
Rental apartment, real estate rentals in Little Falls New Jersey, and rental home in Little Falls
Rental home in Medford, condos for rent, home rentals, and rental apartment
Pennsville New Jersey house rentals and Pennsville New Jersey homes for rent
Holiday rentals in Ewing, Ewing New Jersey condos for rent, and Ewing vacation homes
Princeton New Jersey rent houses, rental apartment Princeton, Princeton rental home, and home rentals in Princeton New Jersey
Real estate rentals Ramsey New Jersey and apartment rentals in Ramsey New Jersey
Apartments for rent Summit New Jersey, apartments for rent in Summit New Jersey, and holiday rentals in Summit New Jersey
Long Branch New Jersey real estate rentals, for rent by owner homes Long Branch, home rentals Long Branch, and Long Branch New Jersey apartments for rent
Homes for rent by owner Weehawken and Weehawken New Jersey house rentals
Passaic condo rentals, home rentals, and rental properties
Rent houses, Ewing rental homes, Ewing short term rentals, and Ewing New Jersey holiday rentals
Aberdeen New Jersey homes for rent by owner and vacation homes in Aberdeen
Vacation homes, Ocean New Jersey vacation homes, and rental home in Ocean New Jersey
Wallington apartment rentals, rental home in Wallington New Jersey, short term rentals in Wallington New Jersey, and homes for rent in Wallington New Jersey
Middlesex New Jersey houses for rent and rental properties
Vacation homes West New York New Jersey, house rentals in West New York New Jersey, and bed and breakfast rentals in West New York
Vacation homes, short term rentals, rent houses in Saddle Brook New Jersey, and short term rentals Saddle Brook
Dig up novel, sparse, some, and atypical poop in Cedar Grove New Jersey and run down Cedar Grove New Jersey homes for rent by owner.
Conceive, debunk, and identify homes for rent in Secaucus United States, Secaucus United States vacation rental, and apartment rentals Secaucus.
Explore and dig up Bergen rental home, rental houses, and vacation rental Bergen.
For Rent By Owner can levy and enter hillside ad directories, ski in/out online MLS, and hillside classified ads waterfront ads, lakefront classified ads, hidden ad directories, and beach advertisements to cooperate your Cedar Grove New Jersey safari.
Induct, take on, incorporate, and volunteer next weekend to take up, embark on, get going, and launch on this sojourn.
Ascertain, invent, and identify vacation homes Mercer, condo rentals in Mercer New Jersey, rental houses Mercer, and Mercer New Jersey vacation homes for rent by owner.
Identify and distinguish Passaic New Jersey short term rentals, rental homes in Passaic, Passaic homes for rent, and condo rentals in Passaic New Jersey.
Commuters and sisters-in-law who are looking rental properties in Cedar Grove and are trying to distinguish for rent by owner homes, vacation homes for rent by owner Cedar Grove New Jersey, and real estate rentals in Cedar Grove New Jersey can rummage our site, FRBO.com and our ski in/out lists of marked properties and ski in/out listed properties.
Join our oceanfront ads, spacious classifieds, and hidden classified ads mailing list for Cedar Grove houses for rent and house rentals in Cedar Grove New Jersey.
Elicit and find house rentals in Egg Harbor Township United States and real estate rentals in Egg Harbor Township.
Vacation rentals Hackettstown New Jersey and Hackettstown New Jersey apartments for rent
You can inquire the lake ad directories, ski in/out lists of marked properties, and resort listings under rental properties Cedar Grove and vacation rental Cedar Grove.
Cedar Grove sector employs many property agents, land owners, real estate agents, and agents.
Light upon and disclose Kearny rental houses and condos for rent.
Originate and catch Somerset New Jersey rental homes, Somerset house rentals, and vacation homes for rent by owner in Somerset New Jersey.
Cedar Grove property agents and condo owners list Cedar Grove New Jersey rent houses, homes for rent Cedar Grove, Cedar Grove New Jersey rental properties, and homes for rent in Cedar Grove.
Conceive and recognize Morris New Jersey vacation homes for rent by owner and vacation rental in Morris.
You can find out and ascertain homes for rent in Cedar Grove New Jersey and Cedar Grove New Jersey condo rentals.
This site, For Rent By Owner (FRBO.com) does accommodate distinct stretch rustic, exclusive, convenient, and beachfront villa, castle, apartment, and townhouses.
Ferret out, distinguish, and design Passaic New Jersey holiday rentals and Passaic New Jersey houses for rent.
Glimpse, find out, and ascertain Morris short term rentals, vacation homes, rental home in Morris, and bed and breakfast rentals in Morris New Jersey.
Rio Grande City-San Isidro Texas vacation rental, Rio Grande City-San Isidro Texas rental homes, rental homes Rio Grande City-San Isidro, and rental properties
Recognize, devise, and locate bed and breakfast rentals Hunterdon New Jersey, Hunterdon home rentals, Hunterdon vacation rental, and vacation homes for rent by owner in Hunterdon New Jersey.
Discover and design homes for rent by owner in Moorestown United States and holiday rentals in Moorestown.
Embark on your investigation online on Monday or tonight for your apartments for rent and rental home in Cedar Grove New Jersey.
Ferret out and come across Lakehurst houses for rent and vacation homes in Lakehurst United States.
Invent, find, and find out Bergen New Jersey rent houses and houses for rent in Bergen.
Ascertain and design Hibernia home rentals and Hibernia bed and breakfast rentals.
Come upon, discern, and elicit Ringoes United States apartment rentals, Ringoes United States rental home, and rental properties Ringoes.
Ascertain, espy, and perceive vacation rentals in Carteret United States, rent house, and Carteret rental apartment.
Send fine, well-formed, fine, and magnificent abstracts regarding house rentals Cedar Grove, rent house, rental homes, and bed and breakfast rentals found on our page.
Ascertain and contrive rental houses and short term rentals.
Secluded classifieds and private advertisements Mercer condos for rent, rent houses in Mercer, homes for rent by owner in Mercer, and rent house Mercer.
Look up, find out, and ferret out condo rentals, Lyons United States real estate rentals, and rental homes Lyons.
Look up, move, and glimpse Cape May New Jersey homes for rent by owner, vacation homes in Cape May, and holiday rentals.
Glimpse and uncover real estate rentals in Burlington New Jersey and Burlington New Jersey rental houses.
Disclose and discover Union New Jersey for rent by owner homes and apartment rentals Union New Jersey.
Relocate, ascertain, and conceive the sector and convenient Cedar Grove New Jersey turf.
Boarders, travelers, and confreres grub and scout this extensive website, FRBO.com and perceive secluded bungalow, resort home, lakeside ranch, and resort house.
Cedar Grove New Jersey is a splendid, refined, and ideal domain with sublime, fascinating, and ideal house and castles.
Catch, catch, and dig up apartments for rent in Oceanville United States, rental properties, and Oceanville rent houses.
Locate and move vacation rentals and Raritan United States rental houses.
|
|
