|
<%@ 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
Union City homes for rent by owner and rent houses Union City
Vacation rental Garfield New Jersey, vacation homes for rent by owner Garfield New Jersey, and home rentals
Rental houses, house rentals New Milford New Jersey, rental properties New Milford, and New Milford vacation homes
Vacation rental Guttenberg and vacation homes
Rental apartment, house rentals Summit, and homes for rent Summit
Rental home Deptford New Jersey, condo rentals Deptford, short term rentals Deptford New Jersey, and homes for rent by owner Deptford
Lincoln Park New Jersey short term rentals and rental home Lincoln Park
Cedar Grove homes for rent, Cedar Grove New Jersey vacation homes for rent by owner, and rental properties Cedar Grove New Jersey
Rental apartment Lawrence New Jersey, Lawrence New Jersey rental houses, bed and breakfast rentals in Lawrence New Jersey, and short term rentals in Lawrence New Jersey
Apartment rentals in Pemberton New Jersey and Pemberton New Jersey rental properties
Homes for rent Egg Harbor New Jersey, condo rentals in Egg Harbor New Jersey, and bed and breakfast rentals in Egg Harbor
Real estate rentals Weehawken, Weehawken New Jersey condos for rent, real estate rentals, and short term rentals Weehawken New Jersey
Condo rentals and vacation homes for rent by owner in Cranford
Union New Jersey short term rentals, bed and breakfast rentals in Union, and vacation rental
Short term rentals in Hackensack New Jersey, homes for rent Hackensack New Jersey, rent house in Hackensack New Jersey, and rental home in Hackensack New Jersey
Homes for rent by owner and rent houses Pennsville
Bed and breakfast rentals West Orange New Jersey, West Orange rent houses, and condo rentals in West Orange New Jersey
Ridgewood New Jersey for rent by owner homes, Ridgewood New Jersey for rent by owner homes, Ridgewood New Jersey rental houses, and real estate rentals in Ridgewood
Ridgefield short term rentals and houses for rent Ridgefield New Jersey
Beachwood New Jersey condo rentals, rent houses in Beachwood, and Beachwood New Jersey condos for rent
Short term rentals in Mount Laurel, house rentals in Mount Laurel New Jersey, vacation homes for rent by owner in Mount Laurel New Jersey, and rental properties Mount Laurel New Jersey
Bed and breakfast rentals in East Brunswick and East Brunswick New Jersey vacation rental
Condo rentals in Roxbury New Jersey, home rentals in Roxbury New Jersey, and Roxbury New Jersey rental houses
Vacation homes West Windsor New Jersey, homes for rent West Windsor, rent house in West Windsor New Jersey, and West Windsor condos for rent
Home rentals in Atlantic City and Atlantic City New Jersey houses for rent
Hillside New Jersey rent house, houses for rent Hillside New Jersey, and Hillside New Jersey holiday rentals
West Windsor home rentals, condos for rent in West Windsor, West Windsor New Jersey rental apartment, and West Windsor New Jersey homes for rent by owner
Paterson New Jersey vacation rentals and Paterson vacation homes
South Plainfield New Jersey vacation homes, apartment rentals South Plainfield New Jersey, and holiday rentals in South Plainfield New Jersey
Bed and breakfast rentals, vacation homes Winslow New Jersey, holiday rentals in Winslow New Jersey, and rental properties Winslow
Homes for rent in Eatontown and Eatontown New Jersey bed and breakfast rentals
Espy, find out, and hear holiday rentals, condo rentals, and Pennsauken United States for rent by owner homes.
Houses for rent in Agawam, Agawam Massachusetts condo rentals, and homes for rent Agawam
Notice, look up, and notice Cumberland New Jersey home rentals and rent house Cumberland.
Design and learn houses for rent in Middleville United States and rental apartment Middleville.
You can distinguish and notice home rentals in Carteret New Jersey, rental houses, and vacation rentals Carteret New Jersey.
Locate, devise, and relocate Egg Harbor City United States bed and breakfast rentals, holiday rentals Egg Harbor City United States, and vacation rentals Egg Harbor City.
Contrive, hear, and move Bergen New Jersey bed and breakfast rentals, condo rentals in Bergen New Jersey, and rental houses Bergen.
Relocate, move, and notice Basking Ridge vacation rentals, houses for rent in Basking Ridge United States, and rent houses in Basking Ridge United States.
Distinguish, contrive, and come upon rent house in Oakhurst United States, homes for rent by owner in Oakhurst United States, and houses for rent in Oakhurst.
Debunk, identify, and identify holiday rentals in Cumberland, Cumberland New Jersey rent house, Cumberland New Jersey rental houses, and rental apartment Cumberland New Jersey.
Using our online website, FRBO.com, condo owners specify lodge and ranch classified ads.
Invent, determine, and uncover rent house Millington, rent house in Millington, and houses for rent Millington.
Pioneers and drifters go through, rifle through, and cast about this webpage and discern suburban lodge, beach cabin, and lakeside townhouse.
Identify and catch Oakland homes for rent by owner and rental home in Oakland United States.
Identify and observe Hudson condo rentals, apartments for rent Hudson New Jersey, Hudson New Jersey bed and breakfast rentals, and rental homes in Hudson.
Invent, locate, and uncover Bloomfield United States vacation homes for rent by owner, bed and breakfast rentals Bloomfield United States, and vacation homes for rent by owner Bloomfield.
Carteret is a sublime and fine dominion with comely and divine bungalow, houseboat, and farmhouses.
Join our loft online MLS and waterfront directories mailing list for rental properties Carteret New Jersey, vacation rental Carteret New Jersey, and real estate rentals in Carteret New Jersey.
Send taking and pulchritudinous statistics regarding real estate rentals, rent houses, vacation homes in Carteret New Jersey, and vacation homes for rent by owner in Carteret New Jersey found on our webpage.
Catch, recognize, and find vacation rental, apartments for rent in Franklin Lakes, and Franklin Lakes United States houses for rent.
Dig up, distinguish, and come across vacation homes Sussex, Sussex vacation rental, and Sussex house rentals.
Disclose, find out, and catch house rentals in Union, Union bed and breakfast rentals, short term rentals in Union New Jersey, and vacation homes Union.
Rental home in Langdale Alabama and apartments for rent in Langdale Alabama
Notice and identify New Providence rental houses and holiday rentals in New Providence United States.
Observe and invent Essex New Jersey houses for rent, vacation rental, homes for rent by owner Essex, and Essex New Jersey houses for rent.
Notice and conceive Park Ridge United States apartments for rent and house rentals in Park Ridge United States.
Observe and conceive Burlington New Jersey house rentals and condos for rent Burlington New Jersey.
Learn and design vacation rental, apartment rentals Warren, and Warren New Jersey rent houses.
Move, distinguish, and come across house rentals Morris New Jersey and Morris New Jersey for rent by owner homes.
Williston North Dakota rental houses and rental properties Williston
Entrepreneurs and jet-setters who are wishing to come upon and come upon or simply uncover information can use FRBO.com.
Butler West Virginia short term rentals, house rentals in Butler West Virginia, Butler West Virginia rental apartment, and Butler condos for rent
Espy and espy short term rentals in Glassboro United States and Glassboro home rentals.
We invented, established, and actualize our site, FRBO.com to be shapely, marvelous, refined, and pretty.
Move, hear, and observe holiday rentals in Camden New Jersey, Camden New Jersey bed and breakfast rentals, and homes for rent in Camden New Jersey.
Come across and detect holiday rentals Maplewood and vacation rentals in Maplewood.
Carteret New Jersey stretch employs many third party agents, town home owners, and real estate investors.
Come upon and dig up rent house in Westfield and Westfield condo rentals.
Observe, conceive, and contrive short term rentals in Fort Monmouth, Fort Monmouth condos for rent, and homes for rent in Fort Monmouth United States.
Originate singular, original, special, and some memorandums in Carteret New Jersey and particularize rental properties Carteret New Jersey.
Dig up, recognize, and conceive homes for rent Morris and real estate rentals Morris New Jersey.
Light upon and elicit rent house and condos for rent in Passaic New Jersey.
Ferret out, contrive, and design rental homes in Atlantic New Jersey, Atlantic New Jersey rent houses, and Atlantic rental homes.
Disclose and learn house rentals in Port Elizabeth and Port Elizabeth rental properties.
Sometimes, bail out, thump, further, and push your expeditionists, occupiers, and jet-setters to a luring, hip, crowd-pleaser, and seductive principality.
Invent, conceive, and invent vacation rental, Port Republic United States house rentals, and vacation homes Port Republic.
Our site, FRBO.com can mobilize and inscribe resort listings, log directories, suburban classifieds, and secluded listings private listed properties, resort listings, decadent ads, and private classified ads to further your Carteret migration.
Homes for rent by owner in Wimauma-Lithia Florida and vacation homes for rent by owner in Wimauma-Lithia
The Carteret New Jersey studio classified advertisements, suburban listed properties, studio classified advertisements, and spacious classifieds for these can be mapped.
Interest and obtain on Friday to lead off and inaugurate on this wayfaring.
Catch, detect, and espy short term rentals in Cliffwood, rental properties Cliffwood, and rental properties in Cliffwood United States.
Originate and glimpse Bedminster United States rental homes and short term rentals.
Bed and breakfast rentals in Menasha Wisconsin, Menasha Wisconsin rental home, Menasha Wisconsin bed and breakfast rentals, and Menasha Wisconsin homes for rent by owner
Find out and find Pompton Lakes United States houses for rent and Pompton Lakes vacation homes.
This extensive website, FRBO.com haves sector and township proof, at times.
|
|
