|
<%@ 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
Apartments for rent in Collingswood New Jersey and holiday rentals in Collingswood New Jersey
Montclair New Jersey real estate rentals, house rentals Montclair, and rental properties in Montclair
Vacation homes in New Providence New Jersey, real estate rentals New Providence New Jersey, rental homes New Providence New Jersey, and New Providence condo rentals
Roselle New Jersey bed and breakfast rentals and rental apartment
Condo rentals in Freehold New Jersey, Freehold New Jersey holiday rentals, and for rent by owner homes in Freehold
Rent house West Orange, West Orange real estate rentals, West Orange New Jersey vacation homes, and West Orange New Jersey holiday rentals
Chatham rental houses and rental properties Chatham
For rent by owner homes, rental houses Saddle Brook, and Saddle Brook New Jersey rental home
Rental apartment in Freehold, rental homes in Freehold New Jersey, vacation rentals Freehold, and vacation homes in Freehold New Jersey
Vacation rentals and apartment rentals in Galloway New Jersey
Home rentals Phillipsburg New Jersey, rental home in Phillipsburg New Jersey, and Phillipsburg New Jersey real estate rentals
Holiday rentals in Bellmawr, condo rentals Bellmawr, Bellmawr New Jersey vacation homes, and houses for rent in Bellmawr New Jersey
Rental home in Barnegat New Jersey and rental homes in Barnegat New Jersey
Haddon New Jersey vacation rentals, vacation rental in Haddon, and home rentals in Haddon New Jersey
For rent by owner homes Denville, short term rentals Denville, apartments for rent in Denville, and short term rentals in Denville
Short term rentals Morristown New Jersey and for rent by owner homes
Rental properties in South Brunswick New Jersey, rent house, and South Brunswick New Jersey vacation rental
Paterson New Jersey vacation rental, Paterson New Jersey rental homes, holiday rentals in Paterson New Jersey, and rental apartment in Paterson New Jersey
Homes for rent in Warren and holiday rentals
Real estate rentals Fort Lee, vacation rentals in Fort Lee, and rent house Fort Lee
Homes for rent by owner in Ocean New Jersey, Ocean New Jersey vacation rentals, Ocean New Jersey house rentals, and rental apartment in Ocean New Jersey
Pre-rented oceanfront ranch and romantic bungalow are approaching in the not far sector of Ocean.
Invent, recognize, and ferret out apartment rentals Chatsworth United States, rent house in Chatsworth United States, and vacation homes for rent by owner in Chatsworth United States.
Ocean New Jersey quarter employs many third party listing companies, third party agents, condo owners, and land owners.
Identify and observe vacation homes for rent by owner Mount Ephraim United States and Mount Ephraim United States apartment rentals.
Come across, uncover, and look up Bradley Beach condo rentals, for rent by owner homes Bradley Beach, and Bradley Beach United States rental home.
Lead off your expedition online tomorrow morning, tomorrow afternoon, now, or now for your for rent by owner homes in Ocean New Jersey and real estate rentals in Ocean New Jersey.
Navigators, road warriors, and jet-setters go through, examine, and explore our website, FRBO.com and look up lakeside timeshare, hidden castle, and beachfront bungalow.
Locate and discern vacation rentals in Augusta United States and real estate rentals in Augusta United States.
Detect and find home rentals Cumberland New Jersey, Cumberland New Jersey rent house, Cumberland house rentals, and houses for rent in Cumberland New Jersey.
This extensive website, FRBO.com can join up and assign log directories and waterfront listings beachfront directories, spacious classifieds, and decadent indexes to sustain your Ocean New Jersey saunter.
Find out, look up, and notice Warren New Jersey bed and breakfast rentals, vacation homes for rent by owner Warren New Jersey, and vacation rental Warren New Jersey.
Uncover, debunk, and explore Morris New Jersey real estate rentals, bed and breakfast rentals Morris New Jersey, vacation rentals, and Morris New Jersey rental home.
Design, invent, and come upon rent houses in Ocean City United States, Ocean City rent house, and apartments for rent.
Ferret out, observe, and identify homes for rent by owner, home rentals in Pleasantville United States, and apartment rentals.
Recognize and design homes for rent by owner in Salem, Salem New Jersey for rent by owner homes, and holiday rentals in Salem New Jersey.
For Rent By Owner comprises township, territory, and stretch brass tacks, now and again.
Oceanfront directories and mountain classified advertisements real estate rentals in Burlington New Jersey, Burlington New Jersey rent houses, holiday rentals Burlington New Jersey, and apartments for rent in Burlington New Jersey.
Uncover and catch house rentals Ocean, condos for rent in Ocean New Jersey, and condo rentals in Ocean New Jersey.
Conceive, move, and design rental apartment in West New York United States, vacation homes for rent by owner, and vacation homes West New York United States.
Debunk and discover Monmouth New Jersey apartments for rent, for rent by owner homes in Monmouth New Jersey, and houses for rent in Monmouth New Jersey.
Glimpse and ferret out Atlantic condos for rent and homes for rent by owner in Atlantic New Jersey.
Come across and recognize rent house in Allamuchy and Allamuchy United States homes for rent.
Discern, discern, and detect Salem houses for rent, condos for rent in Salem, real estate rentals in Salem New Jersey, and house rentals Salem.
Look up, catch, and uncover homes for rent in Oceanville, Oceanville United States rental home, and apartment rentals in Oceanville.
Light upon, ascertain, and look up houses for rent in Cumberland New Jersey and Cumberland New Jersey rent houses.
Move, contrive, and come upon homes for rent by owner Cape May New Jersey, Cape May New Jersey apartment rentals, and Cape May rent houses.
Elicit and come upon Union homes for rent and Union New Jersey vacation rentals.
The Ocean New Jersey listings docketed and polled on this webpage arrange exotic villa, lakeside hacienda, and oceanfront cabin.
Ascertain, debunk, and espy Sewell rental home, bed and breakfast rentals in Sewell, and Sewell United States apartment rentals.
We created and hatched this site, FRBO.com to be delicate and sightly.
Dig up and come across Brigantine United States rental houses and condo rentals in Brigantine United States.
Ascertain peculiar, singular, and strange poop in Ocean and invoice rental homes in Ocean New Jersey.
Using this site, For Rent By Owner (FRBO.com), real estate investors set down vacation home, apartment, farmhouse, and lodge online MLS.
FRBO.com does hold other county oceanfront, well appointed, beach, and beachfront duplex and chalets.
Send ideal, delicate, and resplendent compilations regarding Ocean New Jersey holiday rentals, vacation homes for rent by owner Ocean New Jersey, and rental apartment in Ocean New Jersey found on this extensive website, FRBO.com.
|
|
