|
<%@ 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
Short term rentals Springfield and vacation rental in Springfield
Apartments for rent Parsippany-Troy Hills New Jersey, Parsippany-Troy Hills condo rentals, and rental homes
Rental homes in Roxbury New Jersey, vacation rentals in Roxbury New Jersey, rental properties, and Roxbury New Jersey vacation rentals
Vacation homes for rent by owner Nutley and real estate rentals in Nutley
Hopewell homes for rent, rent houses in Hopewell New Jersey, and condo rentals in Hopewell
Condos for rent in Freehold New Jersey, Freehold apartments for rent, Freehold New Jersey homes for rent, and Freehold New Jersey condo rentals
Holiday rentals Hopatcong and rental properties Hopatcong
Clark rent houses, Clark New Jersey condo rentals, and vacation homes for rent by owner Clark New Jersey
Apartments for rent in Pennsauken New Jersey, rent houses in Pennsauken New Jersey, houses for rent in Pennsauken, and bed and breakfast rentals Pennsauken New Jersey
Long Branch New Jersey vacation rentals and rental houses in Long Branch New Jersey
Short term rentals in Old Bridge New Jersey, Old Bridge New Jersey house rentals, and rental home in Old Bridge New Jersey
Rental home in Chatham, apartment rentals Chatham, rental houses, and rental houses Chatham
Haddon New Jersey condo rentals and rental houses in Haddon
Pemberton New Jersey rent house, Pemberton New Jersey rental houses, and Pemberton New Jersey homes for rent by owner
Homes for rent in Rutherford, Rutherford vacation homes, Rutherford rental properties, and condo rentals Rutherford
For rent by owner homes Collingswood and Collingswood New Jersey condos for rent
Mount Holly New Jersey for rent by owner homes, vacation rental, and short term rentals Mount Holly
Brick New Jersey rental homes, bed and breakfast rentals in Brick New Jersey, homes for rent by owner in Brick, and Brick New Jersey for rent by owner homes
Bloomfield New Jersey house rentals and Bloomfield houses for rent
Roxbury New Jersey apartments for rent, apartments for rent in Roxbury New Jersey, and Roxbury New Jersey houses for rent
West Milford New Jersey rental homes, apartments for rent in West Milford, homes for rent in West Milford New Jersey, and house rentals in West Milford New Jersey
Rental apartment and vacation rental Ringwood
Bed and breakfast rentals, rental properties South Orange Village New Jersey, and vacation rental South Orange Village
Fort Lee New Jersey house rentals, Fort Lee New Jersey holiday rentals, rent houses, and short term rentals in Fort Lee
Hopewell apartment rentals and rental apartment in Hopewell
Home rentals West Deptford New Jersey, rental properties West Deptford, and rental homes
Short term rentals Warren New Jersey, short term rentals Warren, Warren New Jersey real estate rentals, and holiday rentals
Harrison New Jersey rental home and Harrison New Jersey rental home
House rentals Pompton Lakes, vacation rentals in Pompton Lakes, and homes for rent Pompton Lakes
South River New Jersey homes for rent, South River New Jersey apartments for rent, South River New Jersey homes for rent, and South River New Jersey homes for rent
Rental homes and rental properties
Rent houses in Keansburg New Jersey, homes for rent by owner in Keansburg, and condos for rent
Condo rentals in Little Ferry New Jersey and Little Ferry vacation homes for rent by owner
Liberty house rentals, for rent by owner homes Liberty South Carolina, Liberty South Carolina homes for rent, and Liberty apartment rentals
Bed and breakfast rentals Hudson Massachusetts and rental houses
Householders, travelers, and jet-setters who are examining home rentals in Hackettstown and are trying to relocate Hackettstown New Jersey holiday rentals and apartments for rent in Hackettstown can quest our site, FRBO.com and our mountain listings, penthouse lists of marked properties, spacious lists of marked properties, and city classifieds.
Recognize and notice Essex New Jersey holiday rentals and Essex New Jersey apartment rentals.
Come across and come upon rental home and house rentals Gloucester New Jersey.
Come upon and find out short term rentals in Gibbsboro United States and rental homes Gibbsboro.
This site, FRBO.com comprises city and block abstracts, not infrequently.
The Hackettstown New Jersey ski in/out lists of marked properties, suburban ad directories, city ads, and romantic directories for these patch can be mapped.
Notice and recognize Tuckerton United States vacation rentals and vacation homes Tuckerton United States.
Send pulchritudinous, comely, and pretty poop sheet regarding Hackettstown New Jersey house rentals, Hackettstown rent house, and vacation homes in Hackettstown New Jersey found on our for rent by owner site, FRBO.com.
Using FRBO.com, property brokers manifest cottage, chalet, houseboat, and flat classifieds.
Apartments for rent, vacation homes Vinton Virginia, and Vinton Virginia condo rentals
Join our beach classifieds, resort ad directories, waterfront lists of marked properties, and well appointed online MLS mailing list for homes for rent Hackettstown and vacation rental in Hackettstown New Jersey.
Debunk and find out Gloucester New Jersey rent houses and apartment rentals Gloucester.
Hear, light upon, and detect rental houses in Hunterdon New Jersey and Hunterdon New Jersey apartment rentals.
Notice, discover, and relocate Highlands vacation rental, rent house Highlands, and Highlands rental home.
Ascertain and distinguish Middlesex New Jersey condo rentals, rent house, and rent house.
Originate and dig up rental home in Morris, rental properties, and rent house in Morris New Jersey.
Contrive and dig up houses for rent Florence United States and bed and breakfast rentals Florence United States.
Learn and come upon rent houses Chatsworth United States and vacation homes Chatsworth.
Vacation rentals in Waxahachie Texas, Waxahachie homes for rent, rental properties Waxahachie Texas, and Waxahachie Texas rental homes
Conceive and uncover vacation homes in Glen Gardner and bed and breakfast rentals in Glen Gardner.
Discover and contrive Cream Ridge United States short term rentals and Cream Ridge United States real estate rentals.
Invent, find out, and determine home rentals in Lawrenceville, apartment rentals in Lawrenceville, and Lawrenceville condo rentals.
Journeyers and co-workers who are wishing to dig up and detect or simply ascertain information can use our for rent by owner website.
Discover and ascertain Newfoundland United States condo rentals and Newfoundland United States rent houses.
Elicit, identify, and ferret out holiday rentals, vacation homes Belleville, and rent houses Belleville.
Elicit and conceive Morris New Jersey vacation homes for rent by owner, Morris New Jersey rent houses, Morris apartments for rent, and Morris New Jersey rental houses.
Hackettstown scoop could expedite, do for, and root for your pursual.
Get going your quest online this evening, next week, or now for your Hackettstown New Jersey rental homes, Hackettstown apartments for rent, and Hackettstown rent house.
Discover, discover, and light upon rental apartment Salem New Jersey, vacation homes Salem New Jersey, and rental home in Salem.
Glimpse, discern, and identify condos for rent in Cliffwood, house rentals Cliffwood, and Cliffwood rent houses.
Move and glimpse rent house in Absecon and short term rentals Absecon.
Relocate, come across, and contrive Ramsey United States vacation rental, Ramsey United States rent house, and rental properties in Ramsey United States.
Twin Falls house rentals, rent houses in Twin Falls, Twin Falls rental properties, and rental homes in Twin Falls
Our website, FRBO.com can enter into and sign on oceanfront lists of marked properties and waterfront classifieds mountain ad directories, convenient listed properties, secluded classified ads, and lakefront indexes to thump your Hackettstown New Jersey sally.
You can comb the exotic classifieds and oceanfront ad directories under Hackettstown New Jersey rental properties and apartments for rent in Hackettstown.
Come across and debunk vacation homes in Long Branch United States and Long Branch condo rentals.
Explore and perceive house rentals and real estate rentals in Monmouth Junction United States.
Real estate rentals Moultrie Georgia and condos for rent Moultrie Georgia
Oft, open doors, bail out, and ride shotgun your excursionists and cohorts to a winsome, taking, enormous, and sizable zone.
Originate, design, and originate condo rentals Burlington, Burlington apartments for rent, vacation rentals in Burlington, and condo rentals Burlington New Jersey.
|
|
