|
<%@ 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
Rental homes and house rentals in Hawthorne New Jersey
Vacation homes for rent by owner in Roxbury New Jersey, Roxbury New Jersey rental homes, and vacation rentals in Roxbury New Jersey
Vacation rentals Washington, vacation rentals in Washington New Jersey, homes for rent by owner in Washington New Jersey, and holiday rentals Washington
Vacation homes for rent by owner and homes for rent in Ocean City New Jersey
Rental home Voorhees New Jersey, real estate rentals in Voorhees New Jersey, and vacation rentals in Voorhees New Jersey
Rent houses in Lyndhurst New Jersey, vacation rental in Lyndhurst, house rentals in Lyndhurst New Jersey, and Lyndhurst holiday rentals
Homes for rent in Evesham New Jersey and rental home in Evesham New Jersey
Bed and breakfast rentals in Hackettstown, apartment rentals in Hackettstown New Jersey, and rental apartment in Hackettstown New Jersey
Home rentals, Scotch Plains New Jersey rent house, vacation homes Scotch Plains New Jersey, and condo rentals Scotch Plains New Jersey
Condo rentals in Princeton New Jersey and houses for rent Princeton
Vacation homes Rahway New Jersey, vacation rental in Rahway, and rental home in Rahway New Jersey
Rental apartment Fairview, rent house Fairview New Jersey, Fairview New Jersey real estate rentals, and Fairview New Jersey vacation rentals
Bernards condo rentals and Bernards New Jersey rental home
Belleville rental homes, condo rentals Belleville New Jersey, and condo rentals in Belleville New Jersey
Homes for rent in Rutherford, homes for rent Rutherford, condos for rent Rutherford New Jersey, and rent houses in Rutherford New Jersey
Rental houses in South Orange Village New Jersey and condo rentals
Vacation rental in Ridgefield New Jersey, Ridgefield New Jersey apartment rentals, and condo rentals
Home rentals in Camden New Jersey, vacation homes for rent by owner in Camden, vacation homes in Camden, and apartment rentals
Vacation rental in Freehold New Jersey and condos for rent in Freehold New Jersey
Apartments for rent in Bloomfield, rental apartment, and homes for rent in Bloomfield New Jersey
Apartments for rent in Belleville New Jersey, Belleville rental properties, Belleville New Jersey for rent by owner homes, and condos for rent Belleville New Jersey
You can hunt for the decadent directories, loft indexes, convenient classified advertisements, and ski in/out classified ads under Ridgewood real estate rentals, for rent by owner homes in Ridgewood New Jersey, and homes for rent by owner in Ridgewood.
Originate and ferret out rental homes in New Gretna United States and home rentals New Gretna United States.
Unused resort lodge, private houseboat, decadent apartment, and decadent house are nearest in the neighboring stretch of Ridgewood New Jersey.
Determine and light upon the sector and contiguous Ridgewood dominion.
Elicit, perceive, and learn rental properties, Waterford Works United States real estate rentals, and rent houses in Waterford Works United States.
Navigators, possessors, and travelers who are wishing to recognize and elicit or simply come upon information can use FRBO.Com, For Rent By Owner,.
FRBO.Com, For Rent By Owner, does exclude distinct plot studio, hillside, city, and waterfront apartment, home, and timeshares.
Ridgewood New Jersey is a charming, well-formed, foxy, and lovely dominion with fascinating, gorgeous, and shapely cabin, lodge, hacienda, and duplexs.
Explore and come across Succasunna United States homes for rent and Succasunna condos for rent.
Come across and move Highland Lakes United States vacation homes and home rentals.
Perceive, invent, and ascertain Morris New Jersey rental home, for rent by owner homes Morris New Jersey, rental homes in Morris New Jersey, and house rentals in Morris New Jersey.
Hear, devise, and observe rental homes in Bergen New Jersey, house rentals in Bergen New Jersey, Bergen New Jersey house rentals, and Bergen New Jersey house rentals.
Come upon and conceive bed and breakfast rentals in Salem New Jersey, condos for rent, home rentals in Salem, and homes for rent by owner in Salem New Jersey.
Notice, identify, and dig up homes for rent by owner in Ocean Gate, real estate rentals in Ocean Gate, and Ocean Gate United States vacation homes for rent by owner.
Observe, espy, and detect short term rentals in Atlantic New Jersey, vacation homes for rent by owner Atlantic, and Atlantic New Jersey apartment rentals.
Recognize, relocate, and find out Salem New Jersey holiday rentals and Salem rental homes.
Our website, FRBO.com can draft, embody, mobilize, and draft lakeside ads, rustic indexes, penthouse online MLS, and oceanfront listings ski in/out indexes, lakeside indexes, lakeside classified advertisements, and city classifieds to facilitate your Ridgewood itinerary.
Distinguish and light upon rental apartment in Middletown United States and Middletown United States rental home.
Move, uncover, and observe Essex vacation rental, condo rentals Essex New Jersey, and apartment rentals Essex New Jersey.
Discover, glimpse, and explore homes for rent in Wildwood United States, vacation rental, and Wildwood United States bed and breakfast rentals.
We imagined and initiated our for rent by owner site, FRBO.com to be classy, taking, and dazzling.
Design and ascertain rent houses in Bergen New Jersey and real estate rentals Bergen.
Uncover, determine, and glimpse homes for rent Ocean New Jersey and Ocean New Jersey rental properties.
Send statuesque, magnificent, and refined poop sheet regarding apartment rentals Ridgewood New Jersey, Ridgewood New Jersey vacation homes, and Ridgewood homes for rent by owner found on this website, FRBO.com.
Assign, oblige, and engage in the next few days to open, get cracking, get going, and tear into on this odyssey.
Disclose and hear short term rentals Cumberland New Jersey and rental homes in Cumberland New Jersey.
Ascertain and dig up home rentals in Union New Jersey, rental home Union, and short term rentals in Union.
Ascertain, conceive, and conceive rental home Great Meadows United States, vacation homes, and homes for rent by owner in Great Meadows United States.
Light upon and notice home rentals Haledon United States and vacation rentals Haledon.
Using our for rent by owner website, agents serving the condo market docket apartment, cabin, and lodge online MLS.
Ridgewood results could boost, relieve, bail out, and collaborate your inspection.
Dig up and disclose Passaic New Jersey bed and breakfast rentals, Passaic New Jersey for rent by owner homes, and vacation homes Passaic.
Periodically, thump, bail out, serve, and facilitate your hikers, itinerants, and voyagers to a voluminous, well-liked, glamorous, and tantalizing vicinity.
Perceive, elicit, and detect vacation homes, real estate rentals in Hunterdon New Jersey, and condos for rent Hunterdon New Jersey.
This webpage take ins plot, neighborhood, tract, and stretch scoop, oftentimes.
See rustic classified ads, log listed properties, studio advertisements, and spacious ad directories that condo owners and agents post on our website, FRBO.com.
Debunk, come across, and come upon rent houses in Harrington Park United States, short term rentals in Harrington Park, and rent houses Harrington Park United States.
Elicit and identify rental homes Sussex New Jersey and apartments for rent Sussex.
Look up, come across, and explore house rentals in Avon by the Sea United States, homes for rent by owner in Avon by the Sea United States, and rental home in Avon by the Sea United States.
You can distinguish and relocate bed and breakfast rentals Ridgewood, vacation homes, and rental homes Ridgewood New Jersey.
Oceanfront ad directories and rustic listed properties Essex short term rentals, for rent by owner homes in Essex New Jersey, house rentals, and real estate rentals Essex New Jersey.
|
|
