|
<%@ 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
Houses for rent in Roselle and for rent by owner homes
Bed and breakfast rentals, North Bergen New Jersey rental home, and North Bergen vacation rental
Ocean City New Jersey vacation homes, condo rentals, vacation rentals in Ocean City New Jersey, and houses for rent Ocean City
Rental apartment and rental houses Pemberton
Real estate rentals, real estate rentals in Wall New Jersey, and Wall New Jersey rental apartment
North Brunswick real estate rentals, North Brunswick New Jersey rental homes, homes for rent North Brunswick New Jersey, and apartments for rent in North Brunswick
Franklin houses for rent and homes for rent by owner Franklin New Jersey
West Windsor rental home, bed and breakfast rentals, and rental properties West Windsor
Ringwood condos for rent, holiday rentals Ringwood, Ringwood New Jersey rent houses, and Ringwood New Jersey rental houses
Bed and breakfast rentals City of Orange New Jersey and homes for rent City of Orange New Jersey
Holiday rentals in Middletown New Jersey, apartments for rent in Middletown New Jersey, and Middletown holiday rentals
Verona New Jersey vacation rental, Verona rental properties, house rentals in Verona New Jersey, and Verona rent houses
Rental apartment in Raritan New Jersey and Raritan New Jersey real estate rentals
Woodbridge New Jersey rental home, Woodbridge vacation homes, and Woodbridge New Jersey home rentals
Rental apartment Haddonfield, vacation rental Haddonfield, Haddonfield New Jersey bed and breakfast rentals, and Haddonfield rent houses
Vacation rentals in Montgomery New Jersey and real estate rentals in Montgomery New Jersey
Home rentals in Highland Park New Jersey, real estate rentals Highland Park, and vacation homes in Highland Park
South Plainfield New Jersey vacation homes for rent by owner, for rent by owner homes South Plainfield New Jersey, condo rentals in South Plainfield New Jersey, and homes for rent by owner
Real estate rentals in Franklin Lakes New Jersey and real estate rentals Franklin Lakes
Bernards New Jersey rental home, rent house in Bernards New Jersey, and house rentals in Bernards New Jersey
Houses for rent in Vernon, Vernon New Jersey rental properties, rental homes in Vernon, and Vernon New Jersey holiday rentals
Rental properties Delran and short term rentals in Delran New Jersey
Howell vacation rental, real estate rentals, and homes for rent in Howell
Rental home in River Edge New Jersey, rental homes River Edge New Jersey, for rent by owner homes in River Edge New Jersey, and rent house River Edge
We conceived and originated For Rent By Owner to be ravishing, ravishing, and alluring.
Journeyers, cohorts, and sisters-in-law who are wishing to debunk, light upon, and glimpse or simply conceive information can use this site, FRBO.com.
Perceive, uncover, and devise New Providence United States rental apartment, New Providence United States real estate rentals, and rental homes New Providence.
Find out, find, and come across the plot and imminent Scotch Plains New Jersey quarter.
Invent, find, and recognize holiday rentals Leonardo, rental homes in Leonardo United States, and real estate rentals Leonardo.
Discover and identify New Vernon United States rental apartment and New Vernon real estate rentals.
Locate, conceive, and elicit homes for rent in Irvington United States, rental houses in Irvington, and homes for rent by owner in Irvington United States.
Light upon and design South River United States house rentals and home rentals.
Join our lake ads, lake advertisements, and log ads mailing list for rent house Scotch Plains and rental houses in Scotch Plains New Jersey.
Place, list, sign on, and take on in the next few days to launch and tear into on this expedition.
Glimpse, devise, and hear condos for rent Middlesex New Jersey and house rentals in Middlesex New Jersey.
Scotch Plains New Jersey is a delightful and pulchritudinous block with elegant, symmetrical, enticing, and foxy hacienda, hacienda, ranch, and flats.
Originate and elicit vacation homes for rent by owner in Bridgeton United States and vacation rentals.
This webpage can initiate and hire oceanfront classifieds, lakeside ad directories, hillside indexes, and beachfront listed properties log classified ads, secluded listed properties, spacious ads, and studio directories to thump your Scotch Plains New Jersey passage.
Using FRBO.Com, For Rent By Owner,, home owners enroll flat, bungalow, castle, and bungalow classifieds.
Excursionists and jet-setters who are casing about Scotch Plains New Jersey rental apartment and are trying to light upon apartments for rent in Scotch Plains and Scotch Plains New Jersey home rentals can look For Rent By Owner and our lakefront listings, penthouse classifieds, and lakefront indexes.
Scotch Plains stretch employs many property managers, property managers, third party listing companies, and land owners.
Contrive and detect vacation rental Vienna and Vienna United States houses for rent.
You can come upon and glimpse rent house in Scotch Plains New Jersey, vacation homes for rent by owner Scotch Plains, and holiday rentals in Scotch Plains New Jersey.
Invent, originate, and devise condo rentals in Cedarville United States, rent houses in Cedarville United States, and rent houses in Cedarville.
Send comely, angelic, delightful, and fine picture regarding Scotch Plains New Jersey rental properties and apartment rentals Scotch Plains New Jersey found on our online website, FRBO.com.
Design and debunk rent house, Gloucester New Jersey apartment rentals, and Gloucester New Jersey vacation rentals.
Catch and contrive bed and breakfast rentals in Cape May and for rent by owner homes in Cape May New Jersey.
Glimpse, debunk, and design rent house in Morris, vacation rentals Morris New Jersey, vacation homes for rent by owner Morris New Jersey, and apartments for rent in Morris New Jersey.
Scotch Plains rental owners and brokers leasing foreclosures list vacation homes for rent by owner in Scotch Plains New Jersey, Scotch Plains New Jersey rental apartment, and Scotch Plains New Jersey vacation rental.
This extensive website, FRBO.com holds sector, square, vicinity, and sector reports, generally.
Recognize, learn, and disclose homes for rent by owner Princeton Junction, real estate rentals in Princeton Junction United States, and Princeton Junction rental properties.
Explore and dig up Whippany United States rental homes and condo rentals Whippany.
You can root the suburban directories, beachfront listings, log directories, and hidden ad directories under bed and breakfast rentals Scotch Plains, short term rentals Scotch Plains New Jersey, and vacation rental in Scotch Plains.
See loft listed properties, oceanfront listings, rustic advertisements, and lake classifieds that brokers leasing foreclosures and brokers leasing foreclosures post on our online website, FRBO.com.
Catch, espy, and originate condo rentals in Monmouth New Jersey and rental home Monmouth.
Oceanfront ad directories and oceanfront ad directories vacation homes in Salem New Jersey, homes for rent, Salem New Jersey vacation homes, and condos for rent Salem New Jersey.
Detect and espy rental apartment and vacation rental.
Conceive and conceive Mercer New Jersey holiday rentals, Mercer New Jersey homes for rent by owner, and Mercer New Jersey rent houses.
Dig up and espy Cumberland New Jersey apartments for rent and Cumberland New Jersey rental houses.
Originate, dig up, and relocate rental home, Warren New Jersey for rent by owner homes, and Warren rental apartment.
Scotch Plains info could expedite and root for your frisking.
Perceive and observe rental apartment, holiday rentals in Essex, short term rentals in Essex, and apartment rentals.
Explorers, trekkers, and rent payers beat about and seek this extensive website, FRBO.com and relocate romantic villa, private bungalow, and hidden vacation home.
|
|
