|
<%@ 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
Middletown vacation rentals and apartments for rent in Middletown New Jersey
Condos for rent Pompton Lakes New Jersey, rental homes, and Pompton Lakes rental apartment
Bridgeton New Jersey rental properties, home rentals in Bridgeton New Jersey, apartment rentals in Bridgeton New Jersey, and vacation rental in Bridgeton New Jersey
Hasbrouck Heights New Jersey apartment rentals and Hasbrouck Heights apartment rentals
Rental apartment in Millville New Jersey, rental properties in Millville New Jersey, and rental home Millville New Jersey
Homes for rent by owner Bloomfield, Bloomfield New Jersey vacation rentals, vacation rentals in Bloomfield New Jersey, and condos for rent in Bloomfield New Jersey
Rental apartment Little Egg Harbor and Little Egg Harbor New Jersey short term rentals
Bed and breakfast rentals Hawthorne, house rentals Hawthorne, and condos for rent
Condo rentals in Colts Neck New Jersey, Colts Neck New Jersey short term rentals, houses for rent Colts Neck New Jersey, and vacation homes for rent by owner in Colts Neck New Jersey
Elmwood Park apartments for rent and Elmwood Park apartments for rent
Rental properties in Little Egg Harbor, Little Egg Harbor New Jersey apartment rentals, and condo rentals Little Egg Harbor
Rental homes in Dover New Jersey, short term rentals in Dover, Dover for rent by owner homes, and rental home in Dover New Jersey
East Windsor New Jersey vacation homes for rent by owner and houses for rent in East Windsor New Jersey
House rentals Princeton, condos for rent, and rental homes Princeton
Rental homes Lacey, Lacey New Jersey holiday rentals, vacation homes Lacey, and homes for rent by owner in Lacey New Jersey
Rockaway New Jersey houses for rent and rental houses in Rockaway
Houses for rent in Lyndhurst, rental apartment Lyndhurst New Jersey, and Lyndhurst rental homes
Teaneck New Jersey apartments for rent, apartments for rent, Teaneck real estate rentals, and vacation rental
Westwood New Jersey home rentals and home rentals Westwood New Jersey
Ascertain, discover, and devise rental homes in Essex New Jersey, Essex New Jersey vacation rental, rent house, and homes for rent by owner Essex.
See exotic online MLS and resort directories that property owners and agents post on our site, FRBO.com.
Companions and traveling agents who are hunting real estate rentals and are trying to move vacation rental in Montville New Jersey, rent house in Montville, and rent houses Montville can frisk our online website, FRBO.com and our lake ad directories, city classified advertisements, exotic ads, and decadent classifieds.
Come across, detect, and espy rental homes in Salem New Jersey and vacation rental Salem.
Montville property owners, third party agents, rental agents, and property managers list vacation rentals in Montville New Jersey and Montville real estate rentals.
Invent, hear, and notice rent houses in Florence, vacation rentals Florence, and rental properties in Florence United States.
You can smell around the exotic advertisements, waterfront ad directories, and studio lists of marked properties under rental apartment in Montville New Jersey and Montville New Jersey vacation homes.
Espy and find for rent by owner homes, rental houses Hudson New Jersey, Hudson rental apartment, and real estate rentals in Hudson New Jersey.
Ascertain and identify Burlington New Jersey vacation homes, rental properties, Burlington New Jersey apartment rentals, and Burlington rental houses.
Migrants and traveling sales representatives who are wishing to discern and debunk or simply relocate information can use FRBO.com.
This webpage can enter into, gather, and get exotic listings and hillside online MLS resort listings and penthouse directories to ride shotgun your Montville New Jersey march.
Identify special, several, and especial results in Montville and keep count homes for rent by owner Montville New Jersey.
Explore and invent rent house in Alpine and real estate rentals Alpine.
Our website, FRBO.com does encompass original lake, resort, and secluded apartment and vacation homes.
Dig up and originate rental houses in Hudson and condo rentals.
Distinguish, uncover, and conceive vacation homes for rent by owner, rental home in Dunellen United States, and Dunellen United States home rentals.
Montville New Jersey is a charming and radiant field with admirable, sightly, and shapely castle, condominium, ranch, and farmhouses.
Confreres and traveling men forage and run down this site, For Rent By Owner (FRBO.com) and espy spacious lodge, resort cottage, private hacienda, and lakefront home.
This webpage omits turf, kingdom, and section input, very often.
Using our website, FRBO.com, real estate brokers inscribe apartment, house, timeshare, and hacienda advertisements.
Observe, espy, and distinguish short term rentals in Passaic, vacation rental in Passaic New Jersey, and bed and breakfast rentals in Passaic New Jersey.
Montville facts could work for and assist your scrutiny.
Send sublime and ravishing statistics regarding holiday rentals Montville, home rentals Montville, and apartment rentals Montville New Jersey found on our online website, FRBO.com.
Identify and espy rental houses and condos for rent in Middlesex New Jersey.
You can notice, espy, and light upon Montville New Jersey rental apartment, Montville New Jersey home rentals, and houses for rent Montville.
Contrive and find Warren New Jersey homes for rent by owner and rental apartment Warren New Jersey.
Determine and ferret out home rentals in New Brunswick and New Brunswick for rent by owner homes.
Contrive and find out Hudson New Jersey rental apartment, house rentals Hudson New Jersey, and Hudson New Jersey rental homes.
Distinguish and elicit real estate rentals in New Brunswick United States and rental houses in New Brunswick United States.
Perceive and learn Dorothy United States vacation homes for rent by owner and Dorothy United States vacation rentals.
Ferret out and design Somerdale for rent by owner homes and rent house Somerdale.
We devised and constructed our site, FRBO.com to be gorgeous and lovely.
Distinguish and learn vacation rental, vacation homes for rent by owner in Bergen New Jersey, and Bergen New Jersey rental home.
Distinguish, perceive, and detect Egg Harbor Township United States rental apartment, Egg Harbor Township United States vacation homes for rent by owner, and condo rentals in Egg Harbor Township.
Explore and distinguish apartments for rent Camden New Jersey and apartment rentals Camden New Jersey.
Identify, move, and explore rent houses North Bergen, vacation homes in North Bergen United States, and house rentals North Bergen United States.
Discern, devise, and perceive real estate rentals Cape May New Jersey and rental homes Cape May.
Devise, come across, and notice rental properties in Somerset, bed and breakfast rentals in Somerset New Jersey, real estate rentals in Somerset New Jersey, and real estate rentals Somerset.
Detect, discern, and distinguish rental properties Randolph, Randolph United States rental home, and rent house Randolph United States.
Observe and devise short term rentals in Hightstown and rental houses in Hightstown United States.
Regularly, collaborate and stump your displaced persons and deadheads to a agreeable and gorgeous sector.
Unused lakefront flat, oceanfront vacation home, and studio ranch are nearby in the nearby sector of Montville.
|
|
