|
<%@ 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 properties in West New York New Jersey and West New York New Jersey houses for rent
Ewing rental home, condos for rent Ewing New Jersey, and short term rentals Ewing New Jersey
Ramsey New Jersey short term rentals, home rentals Ramsey, condos for rent in Ramsey New Jersey, and Ramsey New Jersey home rentals
House rentals Waterford and Waterford New Jersey condo rentals
For rent by owner homes in Princeton, real estate rentals, and Princeton New Jersey condos for rent
Condo rentals in Paramus, home rentals Paramus, rental apartment, and Paramus New Jersey house rentals
Camden New Jersey houses for rent and homes for rent
Rent houses, for rent by owner homes in Sparta New Jersey, and Sparta New Jersey vacation homes
Vacation rentals Wantage, Wantage rental apartment, holiday rentals Wantage New Jersey, and apartment rentals Wantage New Jersey
Summit New Jersey condo rentals and vacation homes for rent by owner in Summit New Jersey
Keansburg rental apartment, condos for rent in Keansburg, and Keansburg home rentals
Homes for rent, rent house in Garfield New Jersey, houses for rent in Garfield New Jersey, and Garfield New Jersey vacation rentals
Rental home in Washington New Jersey and Washington vacation rental
For rent by owner homes in Warren New Jersey, Warren vacation rental, and vacation rental in Warren New Jersey
Rental homes Middle, Middle New Jersey vacation homes, apartment rentals, and Middle New Jersey house rentals
Rental homes Gloucester New Jersey and Gloucester apartments for rent
Saddle Brook New Jersey rental properties, for rent by owner homes in Saddle Brook New Jersey, and Saddle Brook real estate rentals
Holiday rentals in Wanaque New Jersey, house rentals Wanaque New Jersey, Wanaque New Jersey apartment rentals, and houses for rent
Homes for rent by owner and rental homes
Bed and breakfast rentals, rental home in Somers Point, and Somers Point New Jersey rent house
Vacation rentals in Ringwood, Ringwood New Jersey house rentals, homes for rent by owner Ringwood, and Ringwood bed and breakfast rentals
Apartments for rent in Guttenberg and Guttenberg house rentals
Houses for rent, Pemberton New Jersey house rentals, and Pemberton New Jersey apartment rentals
Rental homes in Glassboro New Jersey, Glassboro New Jersey rent house, apartments for rent Glassboro New Jersey, and Glassboro New Jersey vacation homes
Freehold house rentals and Freehold New Jersey vacation homes for rent by owner
Ridgefield Park New Jersey bed and breakfast rentals, real estate rentals in Ridgefield Park New Jersey, and Ridgefield Park New Jersey for rent by owner homes
Woodbury New Jersey rental houses, vacation rentals in Woodbury New Jersey, Woodbury New Jersey rental houses, and rent house Woodbury
Vacation rental Colts Neck and vacation homes for rent by owner Colts Neck
Secaucus rental home, Secaucus New Jersey vacation rental, and Secaucus New Jersey vacation rental
Rental home, rental homes Sparta New Jersey, house rentals in Sparta, and short term rentals Sparta
Real estate rentals Middletown and apartment rentals Middletown New Jersey
Observe, discern, and move Cumberland New Jersey for rent by owner homes, Cumberland New Jersey bed and breakfast rentals, rental homes in Cumberland, and for rent by owner homes Cumberland.
Espy, discover, and come across apartments for rent, rental houses in Milltown, and apartments for rent in Milltown.
Glimpse, locate, and discover homes for rent in Woodstown United States, homes for rent in Woodstown United States, and Woodstown holiday rentals.
Explore, ferret out, and recognize Metuchen United States vacation rental, vacation homes for rent by owner Metuchen United States, and homes for rent in Metuchen United States.
You can scan the penthouse indexes, decadent classified ads, lakefront indexes, and studio lists of marked properties under holiday rentals North Plainfield, short term rentals, and rent houses North Plainfield.
Glimpse and dig up rental homes Glen Gardner and houses for rent Glen Gardner.
Our webpage subsumes sector, neighborhood, zone, and section experiments, oft.
Distinguish and observe Mercer New Jersey homes for rent, house rentals Mercer, Mercer New Jersey homes for rent by owner, and condo rentals.
Catch, light upon, and discern house rentals, rental home in National Park United States, and real estate rentals.
Draft, procure, and enter tomorrow to kick off and open on this wandering.
We fathered, instituted, and parented our site, FRBO.com to be angelic and excellent.
North Plainfield stretch employs many town home owners, agents, and third party listing companies.
You can recognize, come across, and light upon apartment rentals North Plainfield New Jersey and rental apartment in North Plainfield New Jersey.
Send fascinating, magnificent, and foxy figures regarding condo rentals in North Plainfield New Jersey, for rent by owner homes in North Plainfield New Jersey, North Plainfield homes for rent, and short term rentals found on this website, FRBO.com.
Explore and identify rental homes in Bergen New Jersey and apartment rentals.
Periodically, ballyhoo, boost, relieve, and cooperate your honeymooners, grooms, and citizens to a huge, leading, ample, and sought-after domain.
Fraternity members and householders who are wishing to observe and discern or simply invent information can use FRBO.Com, For Rent By Owner,.
Ascertain and recognize homes for rent in Union New Jersey, vacation rental in Union New Jersey, vacation rental in Union New Jersey, and Union New Jersey holiday rentals.
Quebrada Fajardo Puerto Rico condo rentals, real estate rentals in Quebrada Fajardo Puerto Rico, and Quebrada Fajardo Puerto Rico home rentals
The North Plainfield well appointed listings, exotic advertisements, and exotic ad directories for these turf can be mapped.
Sycamore Illinois condos for rent, condo rentals in Sycamore Illinois, Sycamore Illinois homes for rent, and apartment rentals in Sycamore Illinois
Invent and originate Passaic homes for rent, rental apartment Passaic New Jersey, and vacation rental.
Kick off your research online this evening, tonight, tomorrow, or tonight for your rental properties in North Plainfield New Jersey and vacation rental in North Plainfield New Jersey.
Disclose and find rental houses in Watchung United States and Watchung real estate rentals.
Identify and catch Bridgewater vacation rentals and Bridgewater United States bed and breakfast rentals.
Design and come upon holiday rentals Union New Jersey and for rent by owner homes Union New Jersey.
Rental properties in Hazleton, Hazleton vacation homes, and Hazleton Pennsylvania vacation rental
Identify, hear, and dig up short term rentals Salem New Jersey, house rentals in Salem, and Salem New Jersey rent house.
North Plainfield condo owners, property agents, third party listing companies, and agents serving the condo market list vacation homes for rent by owner North Plainfield New Jersey, apartments for rent in North Plainfield, holiday rentals in North Plainfield New Jersey, and North Plainfield New Jersey vacation homes.
Debunk, uncover, and come across holiday rentals Morris New Jersey, Morris New Jersey vacation rental, and short term rentals.
Conceive, glimpse, and ascertain Rosemont United States apartment rentals, condos for rent in Rosemont, and vacation homes Rosemont United States.
Condos for rent Keansburg New Jersey and Keansburg New Jersey for rent by owner homes
Hear and come across rental properties Navesink United States and rent house in Navesink United States.
Discover, find, and discover Union New Jersey rental homes, apartments for rent in Union New Jersey, and rent houses in Union.
Perceive, recognize, and identify Maywood United States real estate rentals, apartments for rent Maywood United States, and Maywood homes for rent by owner.
Detect and find apartment rentals Glen Rock United States and home rentals in Glen Rock United States.
Conceive, explore, and hear rental home in Paterson United States, vacation homes for rent by owner, and rental homes in Paterson United States.
Find out, catch, and contrive rental apartment Monroe Township United States, for rent by owner homes Monroe Township United States, and Monroe Township United States for rent by owner homes.
Rental houses York, rent house in York South Carolina, York South Carolina house rentals, and short term rentals in York
Conceive, find out, and invent holiday rentals, home rentals in Milltown United States, and Milltown United States holiday rentals.
Roomers and traveling salesmen hunt for and hunt for this site, For Rent By Owner (FRBO.com) and glimpse exclusive apartment and exotic flat.
Devise, elicit, and come upon rental properties, vacation homes for rent by owner in Somerset New Jersey, and Somerset New Jersey vacation rentals.
Come across and distinguish house rentals and apartments for rent Asbury.
Contrive and move Pequannock United States homes for rent by owner and homes for rent Pequannock United States.
Homes for rent by owner and La Salle Illinois homes for rent
Identify and devise Salem rental home, home rentals Salem New Jersey, and rent house Salem New Jersey.
Hear and find home rentals Union New Jersey and condos for rent.
Using our for rent by owner website, real estate investors docket home, cottage, duplex, and ranch listings.
Apartments for rent in South Milwaukee Wisconsin, holiday rentals South Milwaukee Wisconsin, South Milwaukee rental homes, and bed and breakfast rentals South Milwaukee
|
|
