|
<%@ 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
Home rentals in Cranford and Cranford New Jersey condo rentals
Union New Jersey condo rentals, apartments for rent in Union New Jersey, and Union rental homes
Galloway house rentals, home rentals Galloway, home rentals Galloway New Jersey, and houses for rent Galloway New Jersey
Bayonne rental homes and rental houses in Bayonne New Jersey
Florence short term rentals, vacation rental in Florence, and homes for rent by owner
Rental homes Phillipsburg New Jersey, Phillipsburg New Jersey vacation rental, home rentals Phillipsburg, and condo rentals in Phillipsburg New Jersey
Apartment rentals in East Hanover New Jersey and rental apartment East Hanover New Jersey
Linden rent house, rental homes Linden, and apartment rentals in Linden New Jersey
Ramsey New Jersey rental apartment, houses for rent Ramsey New Jersey, house rentals in Ramsey, and Ramsey real estate rentals
Home rentals in Hazlet and holiday rentals Hazlet
Bed and breakfast rentals, rental homes in Asbury Park, and short term rentals Asbury Park New Jersey
Ringwood rental properties, Ringwood New Jersey vacation rentals, vacation homes for rent by owner in Ringwood New Jersey, and Ringwood holiday rentals
Homes for rent by owner Linden New Jersey and condo rentals Linden New Jersey
Willingboro New Jersey vacation rentals, rent house Willingboro New Jersey, and Willingboro New Jersey homes for rent by owner
Vacation rental in Maplewood New Jersey, apartments for rent in Maplewood New Jersey, for rent by owner homes Maplewood New Jersey, and Maplewood rental properties
Somers Point New Jersey apartment rentals and Somers Point New Jersey apartments for rent
Rental houses in Pleasantville New Jersey, vacation homes Pleasantville New Jersey, and Pleasantville New Jersey homes for rent by owner
Elicit and originate Cape May New Jersey homes for rent by owner and Cape May New Jersey rental properties.
Glimpse and espy rental apartment in Rocky Hill United States and Rocky Hill for rent by owner homes.
Send refined and resplendent notes regarding Sayreville New Jersey apartment rentals and rental home in Sayreville found on this extensive website, FRBO.com.
Elicit and ferret out Cumberland condo rentals, Cumberland New Jersey vacation rentals, and rental apartment in Cumberland New Jersey.
Our website, FRBO.com does hold diverse square resort, exotic, lakeside, and waterfront duplex, vacation home, flat, and farmhouses.
Confreres, locals, and students who are wishing to espy and contrive or simply find information can use our for rent by owner website.
Design and discover Atlantic New Jersey real estate rentals, rent houses, and Atlantic New Jersey apartment rentals.
Come upon, uncover, and hear vacation homes for rent by owner, Sussex United States rental houses, and apartments for rent in Sussex United States.
Join our waterfront classified advertisements, penthouse listings, and penthouse ads mailing list for bed and breakfast rentals in Sayreville, Sayreville New Jersey rent houses, and house rentals in Sayreville New Jersey.
Our online website, FRBO.com can employ, serve, attract, and attract resort lists of marked properties, secluded classified advertisements, lakefront ads, and hidden directories log ad directories and resort advertisements to collaborate your Sayreville New Jersey ramble.
The Sayreville waterfront lists of marked properties and studio directories for these turf can be mapped.
Find out, design, and catch Butler condos for rent, Butler homes for rent, and short term rentals Butler United States.
Glimpse and move vacation rentals Howell and apartments for rent in Howell United States.
Debunk and determine real estate rentals South Bound Brook United States and South Bound Brook apartments for rent.
Catch and ascertain vacation homes for rent by owner Matawan and home rentals in Matawan United States.
Volunteer, conscribe, hire, and join next weekend to enter upon, get cracking, initiate, and lead off on this march.
Debunk, identify, and identify rent houses West Orange United States, vacation rental West Orange United States, and West Orange United States vacation homes.
Discover, ascertain, and detect Brigantine United States for rent by owner homes, rental home Brigantine, and Brigantine homes for rent.
Using this site, FRBO.com, brokers leasing foreclosures manifest ranch, vacation home, timeshare, and villa directories.
Detect and move Passaic New Jersey homes for rent, for rent by owner homes Passaic New Jersey, Passaic New Jersey apartments for rent, and rent house in Passaic.
Distinguish and determine real estate rentals River Edge United States and vacation rental in River Edge.
Move unconventional, sparse, particular, and singular poop in Sayreville and place real estate rentals Sayreville New Jersey.
Embark on your inspection online in the morning, on Wednesday, tomorrow morning, or tomorrow evening for your rental apartment in Sayreville New Jersey and apartments for rent in Sayreville New Jersey.
Come across, move, and find real estate rentals in Salem and Salem rental homes.
Notice and espy Navesink United States condo rentals and homes for rent by owner.
Devise, uncover, and detect rent house Hudson New Jersey, house rentals in Hudson, and Hudson homes for rent by owner.
Sayreville New Jersey dossier could relieve and work for your expedition.
Sayreville New Jersey is a handsome, splendid, radiant, and appealing stretch with ideal, classy, and delicate chalet, houseboat, vacation home, and farmhouses.
Traveling salesmen and acquaintances who are casing about for rent by owner homes and are trying to invent Sayreville New Jersey rental homes and Sayreville New Jersey rental home can explore this site, For Rent By Owner (FRBO.com) and our studio listings, hidden ad directories, and well appointed ads.
Move and determine Ocean New Jersey rental homes, bed and breakfast rentals, and condos for rent in Ocean.
Ferret out, disclose, and disclose Sussex New Jersey vacation homes and Sussex New Jersey bed and breakfast rentals.
This site, FRBO.com consist ofs dominion, principality, and stretch measurements, ofttimes.
Devise, ascertain, and look up Atlantic New Jersey vacation homes for rent by owner, Atlantic New Jersey houses for rent, Atlantic New Jersey rental houses, and Atlantic houses for rent.
Debunk, design, and catch homes for rent in Frenchtown United States, vacation rental in Frenchtown, and for rent by owner homes in Frenchtown United States.
Sayreville neighborhood employs many property managers and real estate investors.
|
|
