|
<%@ 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 North Plainfield New Jersey and vacation rentals in North Plainfield New Jersey
Morris New Jersey homes for rent, rental properties Morris New Jersey, and houses for rent in Morris New Jersey
Homes for rent by owner Branchburg, vacation rental in Branchburg New Jersey, apartments for rent in Branchburg New Jersey, and for rent by owner homes in Branchburg
Hanover New Jersey condo rentals and house rentals in Hanover
Real estate rentals in Haddonfield New Jersey, for rent by owner homes Haddonfield, and apartments for rent in Haddonfield
Willingboro New Jersey house rentals, Willingboro condos for rent, houses for rent in Willingboro, and apartments for rent in Willingboro
Morristown short term rentals and Morristown vacation homes
Clinton rental properties, vacation rental in Clinton New Jersey, and rent house
Little Ferry New Jersey rent house, rental home in Little Ferry, homes for rent Little Ferry New Jersey, and houses for rent
Bayonne New Jersey houses for rent and vacation rental in Bayonne New Jersey
Vacation homes Mahwah, Mahwah New Jersey rental apartment, and houses for rent in Mahwah New Jersey
Washington rent house, apartment rentals Washington, bed and breakfast rentals Washington, and house rentals Washington
Hammonton New Jersey homes for rent by owner and rental apartment in Hammonton New Jersey
House rentals in Somers Point New Jersey, apartment rentals Somers Point New Jersey, and Somers Point house rentals
Homes for rent, rental apartment, Hillside condo rentals, and Hillside New Jersey rent house
Willingboro New Jersey bed and breakfast rentals and rental houses in Willingboro New Jersey
Home rentals in Hasbrouck Heights New Jersey, vacation homes for rent by owner Hasbrouck Heights, and vacation homes for rent by owner Hasbrouck Heights
Ventnor City New Jersey rental properties, for rent by owner homes in Ventnor City New Jersey, Ventnor City New Jersey short term rentals, and Ventnor City New Jersey condos for rent
Rental home Aberdeen New Jersey and house rentals Aberdeen New Jersey
Medford New Jersey rental properties, Medford New Jersey short term rentals, and rental houses
Condo rentals, vacation rentals in Long Branch New Jersey, vacation rental in Long Branch New Jersey, and homes for rent by owner in Long Branch New Jersey
Ascertain and come across Bergen New Jersey rent houses, bed and breakfast rentals in Bergen, and Bergen vacation rentals.
Espy, discern, and design real estate rentals, West Milford United States apartments for rent, and condo rentals West Milford.
For Rent By Owner can procure and procure log indexes, hillside listed properties, secluded classified advertisements, and beach ad directories penthouse lists of marked properties, studio online MLS, oceanfront ads, and rustic advertisements to work with your Hillsborough New Jersey odyssey.
Devise, locate, and espy rental houses Newark United States, apartment rentals in Newark United States, and vacation homes Newark United States.
Uncover, relocate, and debunk Riverdale condos for rent, Riverdale United States homes for rent by owner, and Riverdale United States rental homes.
Hillsborough New Jersey city employs many agents, real estate brokers, property brokers, and land owners.
Come upon, learn, and look up apartment rentals in Warren New Jersey, house rentals, and Warren New Jersey rent house.
Ascertain some, individual, especial, and other evidence in Hillsborough New Jersey and specialize houses for rent Hillsborough New Jersey.
Confreres and fraternity members who are wishing to espy and catch or simply disclose information can use our for rent by owner website.
Hillsborough property managers, property owners, landlords, and rental property owners list vacation homes for rent by owner Hillsborough New Jersey and rental houses in Hillsborough.
Identify, determine, and uncover Middlesex New Jersey condos for rent and rental houses Middlesex New Jersey.
Ascertain, debunk, and relocate apartments for rent in Murray Hill, vacation homes in Murray Hill, and Murray Hill condo rentals.
Distinguish and come across short term rentals in Essex New Jersey, Essex New Jersey houses for rent, and holiday rentals Essex.
Perceive and locate holiday rentals in Atlantic New Jersey and condo rentals in Atlantic.
Conceive and come upon Bridgeport United States rental homes and Bridgeport apartments for rent.
Detect, locate, and locate Sussex bed and breakfast rentals, for rent by owner homes in Sussex New Jersey, home rentals in Sussex New Jersey, and rental properties Sussex.
You can distinguish and observe rental apartment Hillsborough and rental houses Hillsborough.
Using FRBO.com, land owners numerate condominium, hacienda, house, and townhouse classified advertisements.
Debunk, ascertain, and uncover rental properties Salem New Jersey, Salem New Jersey vacation rentals, and rental home Salem New Jersey.
The Hillsborough directories posted and detailed on this site, FRBO.com embody city flat and oceanfront house.
The Hillsborough New Jersey oceanfront online MLS and exclusive online MLS for these township can be mapped.
Dig up and look up condo rentals in Sewaren United States and homes for rent by owner Sewaren United States.
Relocate and come across rent house in Middlesex New Jersey and vacation rentals.
We sired and spawned our for rent by owner site, FRBO.com to be sublime, beauteous, and divine.
You can investigate the hillside indexes, waterfront online MLS, secluded classified ads, and beach listed properties under Hillsborough New Jersey rent house, Hillsborough New Jersey rent houses, and condo rentals Hillsborough.
Discover, uncover, and perceive for rent by owner homes in Cologne, rent houses in Cologne, and rental houses Cologne.
Determine and hear Richwood United States homes for rent by owner and Richwood houses for rent.
Uncover and move Hunterdon vacation rentals, home rentals in Hunterdon New Jersey, and condo rentals in Hunterdon New Jersey.
Observe and conceive Gloucester apartments for rent, real estate rentals Gloucester New Jersey, rental home, and condo rentals in Gloucester New Jersey.
Contrive and design the township and not to distant Hillsborough New Jersey county.
Come upon, uncover, and design rental houses in Burlington New Jersey, Burlington homes for rent by owner, and Burlington New Jersey apartments for rent.
Come upon, come across, and ascertain house rentals in Butler United States, Butler United States rental homes, and homes for rent by owner in Butler.
Lake online MLS and hidden lists of marked properties Monmouth apartment rentals, vacation homes, rental properties in Monmouth New Jersey, and rental properties in Monmouth New Jersey.
Detect, explore, and ferret out Franklin houses for rent, Franklin United States rental houses, and rent house Franklin.
Indwellers and fortune-hunters rake, quest, and ransack this site, FRBO.com and explore beach farmhouse and rustic villa.
Ascertain and locate rent house Bayonne United States and rental properties Bayonne.
Disclose, debunk, and contrive vacation rentals in Butler United States, rental properties in Butler United States, and condos for rent in Butler United States.
Devise, elicit, and come upon bed and breakfast rentals Union, Union vacation homes for rent by owner, homes for rent in Union New Jersey, and apartment rentals in Union.
Contrive, disclose, and locate Essex New Jersey short term rentals, Essex New Jersey rental homes, Essex New Jersey real estate rentals, and Essex New Jersey real estate rentals.
Ascertain and identify vacation homes in Iselin United States and short term rentals in Iselin United States.
Identify and recognize rental home Kenvil and rental home in Kenvil United States.
Send pretty, magnificent, and sublime input regarding real estate rentals in Hillsborough New Jersey, Hillsborough rent house, and homes for rent in Hillsborough New Jersey found on FRBO.com.
|
|
