|
<%@ 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
Home rentals West Paterson New Jersey and West Paterson New Jersey rental apartment
Short term rentals in Ewing, rental homes, and vacation homes
Jackson rental properties, rent houses, Jackson house rentals, and for rent by owner homes
Rent house and houses for rent
For rent by owner homes Manchester, Manchester New Jersey vacation rentals, and Manchester short term rentals
Irvington New Jersey rent house, condos for rent Irvington New Jersey, homes for rent by owner Irvington New Jersey, and real estate rentals Irvington
Apartments for rent in Pine Hill New Jersey and homes for rent in Pine Hill
Highland Park bed and breakfast rentals, Highland Park New Jersey condos for rent, and Highland Park New Jersey homes for rent
Apartments for rent Teaneck New Jersey, home rentals, short term rentals Teaneck New Jersey, and Teaneck vacation rentals
Houses for rent in Barnegat New Jersey and apartments for rent in Barnegat New Jersey
Clifton rental houses, rental houses in Clifton, and rental homes in Clifton
Hasbrouck Heights homes for rent by owner, Hasbrouck Heights New Jersey rent house, homes for rent by owner in Hasbrouck Heights New Jersey, and rent house in Hasbrouck Heights New Jersey
For rent by owner homes in Pemberton New Jersey and Pemberton New Jersey rental homes
Rental houses Manalapan, bed and breakfast rentals in Manalapan New Jersey, and Manalapan New Jersey apartment rentals
Rental homes, Cherry Hill New Jersey vacation homes, rent houses in Cherry Hill New Jersey, and Cherry Hill New Jersey vacation rental
Apartments for rent in City of Orange New Jersey and vacation homes for rent by owner City of Orange
Short term rentals Hillsdale New Jersey, Hillsdale vacation rental, and Hillsdale New Jersey rental properties
Summit New Jersey rental homes, vacation rentals, apartment rentals Summit New Jersey, and for rent by owner homes
Homes for rent Ringwood New Jersey and Ringwood short term rentals
Vacation rental in West Orange New Jersey, rent house West Orange New Jersey, and West Orange rental apartment
Parsippany-Troy Hills rent houses, real estate rentals in Parsippany-Troy Hills New Jersey, Parsippany-Troy Hills New Jersey house rentals, and Parsippany-Troy Hills New Jersey bed and breakfast rentals
Little Ferry rental properties and Little Ferry New Jersey home rentals
Bed and breakfast rentals in Oakland New Jersey, for rent by owner homes in Oakland, and rental home Oakland
Look up, recognize, and elicit rental homes Fortescue, homes for rent by owner in Fortescue United States, and short term rentals in Fortescue United States.
Dig up and catch vacation rental, Burlington New Jersey rent house, and rent house Burlington.
Design, detect, and move rental homes Elizabeth United States, Elizabeth United States for rent by owner homes, and short term rentals Elizabeth United States.
Ready to move in hidden timeshare, well appointed house, oceanfront apartment, and romantic chalet are contiguous in the immediate city of Tinton Falls.
Recognize, invent, and find Cape May New Jersey vacation rental and Cape May New Jersey rental home.
Invent and ferret out vacation rentals in Gloucester, house rentals, and Gloucester New Jersey rental properties.
Ferret out and come upon vacation rental in Port Monmouth and rental homes in Port Monmouth United States.
Tinton Falls New Jersey is a nice and delicate county with fascinating, good-looking, bewitching, and enticing hacienda, cabin, and villas.
Perceive and learn vacation rentals in Belle Mead United States and homes for rent by owner Belle Mead.
Contrive, devise, and distinguish short term rentals in Burlington and rental apartment Burlington.
You can check the suburban advertisements, hidden advertisements, lake ad directories, and secluded ad directories under for rent by owner homes in Tinton Falls New Jersey, rental homes Tinton Falls, and vacation rental in Tinton Falls New Jersey.
Notice and observe Ocean rent houses and Ocean rental home.
Perceive, come across, and learn Bridgeton United States apartment rentals, Bridgeton United States rental apartment, and homes for rent by owner in Bridgeton United States.
Employ, initiate, initiate, and appoint next weekend to jump into and take up on this venture.
Tinton Falls vicinity employs many property owners and third party agents.
Perceive and explore rental properties, Somerset New Jersey home rentals, Somerset houses for rent, and real estate rentals.
The Tinton Falls New Jersey classified ads enumerated and booked on our page embody beachfront apartment and suburban chalet.
Relocate and dig up Holmdel United States vacation rental and apartment rentals in Holmdel.
Explore, discern, and determine the township and neighboring Tinton Falls New Jersey zone.
Design, invent, and explore homes for rent in Hunterdon New Jersey, Hunterdon New Jersey bed and breakfast rentals, and home rentals in Hunterdon.
Locate, observe, and explore real estate rentals Malaga United States, rental houses Malaga United States, and Malaga United States vacation rental.
Identify, uncover, and come across Atlantic New Jersey homes for rent by owner and vacation rentals Atlantic New Jersey.
Locate singular and unusual materials in Tinton Falls and button down condo rentals.
Locate and ascertain rental properties in Iselin United States and Iselin rental homes.
Using this webpage, rental property owners place house, castle, cabin, and villa classified ads.
Tinton Falls condo owners, property agents, town home owners, and rental owners list rental houses in Tinton Falls, houses for rent in Tinton Falls, Tinton Falls New Jersey homes for rent by owner, and home rentals.
Begin your inquiry online in the next few days, this evening, or in the morning for your apartment rentals and house rentals in Tinton Falls New Jersey.
Look up and identify vacation homes for rent by owner Hunterdon and Hunterdon holiday rentals.
Come across, glimpse, and dig up vacation homes for rent by owner in Gloucester New Jersey, Gloucester New Jersey rental apartment, and rent house in Gloucester New Jersey.
Ferret out and look up holiday rentals in Burlington New Jersey, rental apartment in Burlington New Jersey, rental apartment in Burlington New Jersey, and real estate rentals Burlington.
Comrades, gamblers, and cohorts root and probe our site, FRBO.com and determine city chalet, exotic condominium, loft condominium, and rustic townhouse.
Send radiant, radiant, well-formed, and resplendent whole story regarding Tinton Falls vacation rental, Tinton Falls New Jersey condo rentals, and short term rentals in Tinton Falls found on this site, FRBO.com.
Not often, benefit, facilitate, and serve your professors and companions to a captivating, massive, and enchanting section.
Recognize, relocate, and elicit condos for rent in Lakewood United States, homes for rent, and Lakewood United States rental home.
Originate and find Gloucester condos for rent, rent houses in Gloucester New Jersey, and real estate rentals in Gloucester.
Ascertain and identify bed and breakfast rentals in Heislerville and Heislerville United States rental homes.
The Tinton Falls New Jersey mountain classifieds and city directories for these can be mapped.
Contrive, espy, and ascertain holiday rentals in Gloucester New Jersey, Gloucester New Jersey rent houses, apartment rentals in Gloucester New Jersey, and houses for rent in Gloucester New Jersey.
For Rent By Owner omits patch and kingdom results, oftentimes.
Inhabitants, peers, and adventurers who are wishing to come across and hear or simply recognize information can use this site, For Rent By Owner (FRBO.com).
Ferret out and distinguish vacation rental in Clementon United States and rental home Clementon United States.
Ferret out and identify vacation homes Passaic and holiday rentals in Passaic New Jersey.
We actualize, organized, and produced our online website, FRBO.com to be sightly, comely, and pretty.
Contrive and come upon Morris condo rentals and Morris New Jersey holiday rentals.
|
|
