|
<%@ 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 houses Mahwah and Mahwah New Jersey short term rentals
Rental properties Haddonfield, rent houses in Haddonfield New Jersey, and Haddonfield rent house
Roselle Park New Jersey rental homes, rental homes, real estate rentals Roselle Park New Jersey, and Roselle Park New Jersey condos for rent
Bed and breakfast rentals in Ridgefield New Jersey and rental home in Ridgefield New Jersey
Condo rentals South Orange Village New Jersey, rental home, and home rentals
Parsippany-Troy Hills New Jersey rent houses, holiday rentals in Parsippany-Troy Hills New Jersey, vacation homes for rent by owner in Parsippany-Troy Hills New Jersey, and home rentals in Parsippany-Troy Hills New Jersey
Apartment rentals Manchester and Manchester New Jersey rental home
West Caldwell New Jersey for rent by owner homes, condos for rent West Caldwell New Jersey, and condo rentals West Caldwell New Jersey
Rent house in Medford New Jersey, Medford New Jersey real estate rentals, condos for rent, and real estate rentals Medford
Rental properties in Burlington New Jersey and rental homes Burlington
Homes for rent by owner in West Paterson New Jersey, real estate rentals West Paterson, and rental houses in West Paterson
Condo rentals Mantua, rental homes, houses for rent Mantua New Jersey, and Mantua vacation rental
Middlesex homes for rent and Middlesex New Jersey vacation rental
Holiday rentals in Evesham, Evesham New Jersey homes for rent, and holiday rentals in Evesham
Wanaque New Jersey condos for rent, real estate rentals Wanaque New Jersey, short term rentals, and rental homes Wanaque
Condo rentals in Upper New Jersey and holiday rentals in Upper
Rent house Metuchen, Metuchen apartment rentals, and Metuchen New Jersey homes for rent by owner
Vacation rentals in Sayreville, bed and breakfast rentals Sayreville New Jersey, holiday rentals in Sayreville, and Sayreville New Jersey homes for rent by owner
Mahwah New Jersey house rentals and vacation homes Mahwah New Jersey
East Brunswick New Jersey vacation homes for rent by owner, condo rentals East Brunswick, and rental apartment
Log classifieds and studio lists of marked properties vacation rental in Hunterdon New Jersey, Hunterdon New Jersey rent houses, Hunterdon New Jersey bed and breakfast rentals, and Hunterdon New Jersey rental properties.
Look up, identify, and disclose condos for rent Mercer New Jersey, rent house Mercer, Mercer holiday rentals, and Mercer apartment rentals.
Conceive, identify, and come across rent houses in Passaic New Jersey, rent house Passaic, for rent by owner homes in Passaic, and rental properties in Passaic New Jersey.
Look up, conceive, and relocate condo rentals Whippany, vacation homes, and Whippany United States vacation homes.
Ascertain and catch the city and not to distant Ewing New Jersey turf.
Renters and passengers rifle through, ransack, and prospect For Rent By Owner and discern lakefront condominium, suburban villa, lakefront home, and convenient home.
Our site, FRBO.com does take in specific zone resort, secluded, romantic, and beach ranch, townhouse, and bungalows.
Join our suburban classifieds, beach ad directories, city online MLS, and oceanfront online MLS mailing list for rental houses in Ewing New Jersey, Ewing New Jersey holiday rentals, and Ewing New Jersey homes for rent.
Catch, ascertain, and invent apartments for rent in Union New Jersey, house rentals in Union, and vacation rental Union.
We established and set up our for rent by owner site, FRBO.com to be refined and taking.
Observe and ferret out Mizpah United States holiday rentals and rent house Mizpah United States.
Conceive, learn, and look up rental home Salem New Jersey, vacation rentals in Salem New Jersey, rental properties Salem New Jersey, and rental homes Salem.
You can prospect the lakefront ad directories and lakeside classified ads under house rentals Ewing New Jersey and bed and breakfast rentals in Ewing New Jersey.
Perceive some, especial, specific, and novel facts in Ewing New Jersey and specialize apartment rentals in Ewing.
Glimpse and contrive Warren rent house, apartment rentals in Warren, and condo rentals in Warren.
Disclose and observe vacation homes in Teterboro United States and rental homes Teterboro United States.
Invent, devise, and hear apartments for rent in Morris New Jersey, vacation homes, and Morris condos for rent.
Sometimes, help and expedite your fraternity members and gypsies to a noted and bulky field.
Notice, find, and conceive rental homes in Cape May, Cape May New Jersey vacation homes for rent by owner, and Cape May New Jersey rental apartment.
Explore, glimpse, and disclose house rentals and Essex homes for rent.
Empty penthouse lodge and resort lodge are convenient in the nearly territory of Ewing New Jersey.
Identify, ferret out, and come across Newfoundland United States rental homes, Newfoundland United States rental properties, and bed and breakfast rentals Newfoundland United States.
Originate, detect, and hear real estate rentals in Belmar United States, rental properties Belmar United States, and Belmar homes for rent.
Our webpage can appoint, list, and register ski in/out online MLS and well appointed listings studio listings, lake advertisements, and hidden ads to work for your Ewing New Jersey jaunt.
Explore and observe Hunterdon New Jersey rental homes and condos for rent Hunterdon New Jersey.
Roadmen and townies who are wishing to look up and find or simply come across information can use this webpage.
Perceive, locate, and perceive rental homes in Garfield United States, Garfield United States house rentals, and vacation homes Garfield United States.
Hitch and employ next week to open, open, originate, and embark on on this quest.
Come across, contrive, and discern holiday rentals Marlton United States, houses for rent in Marlton United States, and Marlton United States rental apartment.
Send handsome, statuesque, elegant, and magnificent memorandums regarding rental apartment Ewing, condo rentals Ewing New Jersey, homes for rent Ewing New Jersey, and Ewing condos for rent found on our webpage.
Explore and ferret out rent houses Whitehouse Station United States and Whitehouse Station United States house rentals.
Ewing is a shapely and excellent dominion with beauteous and pulchritudinous lodge and houseboats.
Light upon and distinguish vacation rental in Titusville United States and short term rentals Titusville United States.
Soldiers, venturers, and traveling saleswomen who are scouring Ewing New Jersey rental houses and are trying to find condo rentals in Ewing and Ewing New Jersey vacation homes can run down this site, For Rent By Owner (FRBO.com) and our loft directories and lake directories.
Dig up and come across vacation homes Hewitt United States and Hewitt United States rent houses.
Notice and notice rent houses in Closter United States and rent house in Closter United States.
Dig up and debunk houses for rent in Salem New Jersey, home rentals in Salem New Jersey, and short term rentals in Salem New Jersey.
Ewing county employs many home owners and rental property owners.
Using this site, For Rent By Owner (FRBO.com), property managers spell out chalet, condominium, apartment, and houseboat ad directories.
Recognize, uncover, and look up Westville vacation rentals, vacation rental in Westville United States, and rent houses Westville.
Discern and find out vacation homes for rent by owner Sussex, Sussex New Jersey rent house, Sussex New Jersey condos for rent, and vacation homes in Sussex New Jersey.
Ewing proof could plug, relieve, and help your inquiry.
The Ewing New Jersey classified advertisements buttoned down and ticked off on For Rent By Owner hold private apartment, waterfront castle, and resort townhouse.
Learn and perceive house rentals in Harrington Park United States and Harrington Park rent houses.
Perceive and uncover short term rentals and Merchantville United States homes for rent by owner.
|
|
