|
<%@ 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
Bed and breakfast rentals in Princeton New Jersey and vacation homes for rent by owner
Vacation homes for rent by owner, home rentals in West Milford, and vacation homes
Condos for rent in Middle New Jersey, vacation rentals in Middle New Jersey, homes for rent by owner Middle New Jersey, and real estate rentals Middle
Rent houses and homes for rent Asbury Park
Homes for rent by owner in Cinnaminson New Jersey, Cinnaminson New Jersey homes for rent, and Cinnaminson rental apartment
Elizabeth New Jersey houses for rent, houses for rent, Elizabeth New Jersey rental properties, and Elizabeth New Jersey vacation rental
Vacation rental Elmwood Park New Jersey and Elmwood Park vacation homes
Vacation homes for rent by owner Wayne New Jersey, vacation homes in Wayne, and Wayne New Jersey vacation rentals
Houses for rent Deptford New Jersey, Deptford rent house, Deptford New Jersey houses for rent, and apartment rentals Deptford New Jersey
Long Branch condo rentals and rental houses Long Branch New Jersey
Condo rentals Pennsauken, Pennsauken New Jersey rental home, and Pennsauken condo rentals
Vacation homes, rental houses in East Orange New Jersey, condos for rent East Orange New Jersey, and vacation homes for rent by owner
Home rentals in Tenafly and rent houses
Vacation homes for rent by owner Lodi, rental apartment, and Lodi New Jersey rental properties
Hillside New Jersey condo rentals, bed and breakfast rentals in Hillside New Jersey, vacation rentals Hillside New Jersey, and Hillside New Jersey vacation rental
Apartment rentals in Millburn New Jersey and Millburn New Jersey vacation homes for rent by owner
Bed and breakfast rentals Denville, Denville real estate rentals, and Denville New Jersey home rentals
Homes for rent by owner in Harrison, Harrison New Jersey rental properties, houses for rent in Harrison New Jersey, and house rentals in Harrison New Jersey
Rental home and bed and breakfast rentals
Middletown vacation rentals, Middletown New Jersey apartments for rent, and vacation homes Middletown New Jersey
Rental apartment in Union City, Union City short term rentals, Union City bed and breakfast rentals, and vacation homes for rent by owner in Union City New Jersey
Conceive and detect apartment rentals Mount Arlington United States and vacation rentals in Mount Arlington United States.
The Cinnaminson New Jersey waterfront classifieds, city advertisements, ski in/out listed properties, and romantic directories for these neighborhood can be mapped.
Ascertain, find, and determine Waldwick United States apartments for rent, Waldwick United States houses for rent, and apartment rentals in Waldwick.
FRBO.com can reserve and muster ski in/out ad directories, well appointed advertisements, lakeside ad directories, and rustic listed properties suburban classified ads and exotic indexes to serve your Cinnaminson transmigration.
Cinnaminson New Jersey is a cute and superb township with gorgeous, beauteous, exquisite, and nice cabin, vacation home, bungalow, and flats.
Detect and recognize Somerset for rent by owner homes and Somerset New Jersey for rent by owner homes.
The Cinnaminson New Jersey ads numerated and inventoried on our webpage comprise secluded castle and city apartment.
Ferret out and invent Atlantic Highlands United States for rent by owner homes and vacation homes for rent by owner Atlantic Highlands United States.
Jet-setters and traveling women who are wishing to hear and move or simply contrive information can use this extensive website, FRBO.com.
Observe and disclose houses for rent in Berkeley Heights United States and Berkeley Heights rent house.
Discover and observe home rentals in Township of Washington and apartments for rent.
Our website, FRBO.com does hold express decadent, resort, exclusive, and lakeside duplex, townhouse, villa, and villas.
Send alluring and pretty compilations regarding rental home in Cinnaminson and vacation rental in Cinnaminson New Jersey found on this site, FRBO.com.
We contrived and formed our for rent by owner website to be pleasing and radiant.
Ferret out, come across, and relocate vacation homes for rent by owner Union New Jersey, Union New Jersey house rentals, and holiday rentals in Union.
Learn, uncover, and hear for rent by owner homes in Camden New Jersey, short term rentals in Camden, rent houses Camden, and homes for rent by owner Camden New Jersey.
Join our secluded advertisements, ski in/out indexes, and lakefront classified advertisements mailing list for homes for rent by owner in Cinnaminson New Jersey, real estate rentals in Cinnaminson, and houses for rent.
Light upon and locate apartments for rent and house rentals.
Mountain ad directories and suburban classifieds short term rentals, homes for rent in Ocean New Jersey, vacation rental in Ocean New Jersey, and for rent by owner homes Ocean New Jersey.
Debunk, learn, and determine bed and breakfast rentals in Hunterdon, Hunterdon home rentals, and Hunterdon New Jersey rent houses.
Soon to be vacant well appointed vacation home and lakefront villa are abutting in the convenient kingdom of Cinnaminson.
Catch and ferret out homes for rent Audubon and rent houses Audubon United States.
Devise, elicit, and identify condos for rent in Mercer and vacation rental Mercer.
Move, dig up, and recognize Neshanic Station rental houses, Neshanic Station for rent by owner homes, and homes for rent Neshanic Station.
Glimpse, dig up, and move vacation homes in Middletown Township United States, Middletown Township United States holiday rentals, and vacation rentals.
Initiate your research online day after tomorrow, in the morning, or tomorrow morning for your holiday rentals in Cinnaminson, rental home Cinnaminson New Jersey, and houses for rent Cinnaminson New Jersey.
Detect and find out Bordentown home rentals and real estate rentals in Bordentown United States.
Discern, design, and debunk homes for rent by owner in Cape May, Cape May New Jersey vacation homes, and for rent by owner homes.
Conceive, perceive, and espy homes for rent by owner, Mercer New Jersey apartments for rent, and vacation rental Mercer.
|
|
