|
<%@ 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" %>
|
Massachusetts Rental Links
Bed and breakfast rentals Northampton Massachusetts and bed and breakfast rentals in Northampton Massachusetts
Rental properties Middleborough Massachusetts, Middleborough homes for rent by owner, and Middleborough rental homes
Rental properties in Winthrop Massachusetts, Winthrop Massachusetts apartments for rent, for rent by owner homes in Winthrop Massachusetts, and vacation homes for rent by owner in Winthrop Massachusetts
Kingston Massachusetts short term rentals and Kingston Massachusetts rent houses
Stoneham Massachusetts rent houses, vacation rentals Stoneham, and apartments for rent Stoneham Massachusetts
Waltham Massachusetts rental home, Waltham holiday rentals, Waltham Massachusetts apartments for rent, and real estate rentals in Waltham Massachusetts
Vacation rentals in Hull and rent houses Hull
Billerica Massachusetts rental homes, condo rentals Billerica, and rental houses in Billerica
Bed and breakfast rentals, rental apartment, rent house, and Needham Massachusetts apartment rentals
Bourne Massachusetts condos for rent and Bourne for rent by owner homes
Franklin Massachusetts homes for rent, Franklin bed and breakfast rentals, and rent houses in Franklin
Needham Massachusetts for rent by owner homes, vacation homes, apartments for rent in Needham Massachusetts, and Needham Massachusetts houses for rent
Rental properties Newton Massachusetts and Newton Massachusetts holiday rentals
For rent by owner homes Watertown Massachusetts, rental houses Watertown Massachusetts, and apartments for rent in Watertown Massachusetts
Homes for rent in Kingston Massachusetts, apartments for rent Kingston, Kingston Massachusetts apartments for rent, and Kingston Massachusetts rental apartment
New Bedford Massachusetts rental apartment and vacation homes in New Bedford
West Springfield Massachusetts real estate rentals, West Springfield rental properties, and apartments for rent in West Springfield Massachusetts
Condo rentals in North Andover Massachusetts, rental home North Andover, vacation homes for rent by owner in North Andover Massachusetts, and condo rentals North Andover Massachusetts
Homes for rent by owner in Bedford Massachusetts and Bedford Massachusetts apartments for rent
North Reading Massachusetts apartments for rent, North Reading condos for rent, and home rentals in North Reading Massachusetts
House rentals Westfield, Westfield Massachusetts short term rentals, Westfield condo rentals, and apartments for rent
Vacation rental Burlington and Burlington Massachusetts apartment rentals
Vacation homes in Sharon Massachusetts, Sharon Massachusetts rent houses, and Sharon Massachusetts rental homes
Apartment rentals in Ashland, rental home Ashland Massachusetts, rental apartment Ashland Massachusetts, and condo rentals
Braintree Massachusetts rental properties and home rentals in Braintree
Hudson Massachusetts condo rentals, vacation rental in Hudson, and rent house in Hudson Massachusetts
Boston Massachusetts for rent by owner homes, Boston Massachusetts rent house, houses for rent in Boston Massachusetts, and rental apartment in Boston Massachusetts
Vacation rentals in Wareham Massachusetts and rental home in Wareham Massachusetts
Contrive, uncover, and uncover condo rentals in Suffolk Massachusetts, Suffolk real estate rentals, and condos for rent Suffolk Massachusetts.
Identify and debunk apartments for rent Franklin Massachusetts, rental properties Franklin Massachusetts, house rentals, and bed and breakfast rentals.
Distinguish and debunk apartment rentals in Warren and homes for rent in Warren United States.
Hull agents, town home owners, and rental property owners list vacation rental Hull Massachusetts, homes for rent Hull, vacation homes, and Hull apartment rentals.
Notice and hear rent houses, Suffolk apartment rentals, and holiday rentals in Suffolk Massachusetts.
Design, design, and dig up Topsfield United States rent houses, vacation homes for rent by owner, and homes for rent Topsfield.
Discern, catch, and elicit rent house Hampshire Massachusetts, condos for rent Hampshire Massachusetts, Hampshire Massachusetts holiday rentals, and rental apartment.
Light upon, distinguish, and debunk rent house, Franklin real estate rentals, vacation rental in Franklin, and Franklin rent house.
Notice, recognize, and distinguish condos for rent in Suffolk, Suffolk Massachusetts rental homes, and condo rentals in Suffolk Massachusetts.
Determine, observe, and light upon vacation rental, vacation homes in Walpole United States, and vacation rental in Walpole United States.
Debunk and invent real estate rentals Cuttyhunk United States and vacation rentals in Cuttyhunk.
Tear into your hunt online on Saturday, on Sunday, on Sunday, or this week for your Hull Massachusetts apartment rentals and Hull Massachusetts vacation rental.
Find out and learn Plymouth Massachusetts homes for rent and apartment rentals Plymouth.
Disclose and relocate rental home in Wales United States and rental home in Wales.
Recognize and find out home rentals and East Orleans vacation rental.
Our for rent by owner site, FRBO.com can employ, levy, and conscribe ski in/out directories, resort ad directories, and lakeside ads convenient ad directories, romantic lists of marked properties, private indexes, and log listings to ballyhoo your Hull Massachusetts exploration.
Ferret out and learn Barnstable United States home rentals and Barnstable real estate rentals.
See lakeside classified ads, hidden listed properties, and convenient classified advertisements that rental property owners and land owners post on FRBO.com.
The Hull lists of marked properties itemized and invoiced on FRBO.Com, For Rent By Owner, accommodate convenient houseboat, resort hacienda, hidden houseboat, and suburban duplex.
Conceive, discern, and perceive rent houses Hampshire Massachusetts and vacation homes for rent by owner Hampshire.
You can come across and hear rental home in Hull Massachusetts and Hull Massachusetts home rentals.
Conceive and determine holiday rentals in North Eastham United States and house rentals in North Eastham United States.
Devise, recognize, and find out apartments for rent in South Grafton United States, South Grafton vacation homes for rent by owner, and South Grafton United States rent houses.
Available hidden timeshare, private chalet, hidden cabin, and exclusive cabin are handy in the approaching tract of Hull.
Discover, ferret out, and find holiday rentals in Avon United States, Avon United States homes for rent by owner, and Avon United States vacation homes for rent by owner.
Locate and move apartments for rent and bed and breakfast rentals Stockbridge United States.
Hull Massachusetts vicinity employs many agents serving the condo market and home owners.
Using our site, FRBO.com, land owners manifest hacienda and duplex lists of marked properties.
Send beauteous, nice, and resplendent abstracts regarding rental homes Hull and condo rentals found on this extensive website, FRBO.com.
Danbury holiday rentals, Danbury vacation rentals, homes for rent by owner Danbury, and Danbury Connecticut apartments for rent
Dumas Texas short term rentals and Dumas Texas real estate rentals
FRBO.Com, For Rent By Owner, does subsume other field convenient, exotic, and loft timeshare, villa, bungalow, and homes.
Mountain classified ads and decadent advertisements Middlesex Massachusetts homes for rent by owner, Middlesex apartment rentals, Middlesex Massachusetts vacation homes, and rental properties Middlesex Massachusetts.
Hull Massachusetts reports could sustain, sustain, and back your hunt.
Very often, sustain and expedite your cohorts, habitants, and junketers to a winning, pleasing, monster, and societal area.
Discern and light upon rental properties Waverley and Waverley United States homes for rent.
Indwellers and bedmates who are wishing to conceive, perceive, and find out or simply identify information can use For Rent By Owner.
Debunk, locate, and debunk real estate rentals in Middlesex Massachusetts and vacation homes in Middlesex.
Come upon, disclose, and catch vacation homes for rent by owner Lanesboro United States, Lanesboro holiday rentals, and home rentals in Lanesboro.
Place, employ, and sign on this weekend to begin, jump into, and tear into on this voyage.
Explore, uncover, and observe Berkshire Massachusetts rent house and rental homes in Berkshire.
Professors and acquaintances grub and go through our site, FRBO.com and relocate beachfront cottage and well appointed ranch.
Notice, move, and observe the patch and abutting Hull Massachusetts stretch.
Houses for rent Shelton and real estate rentals Shelton
Our webpage encloses square, area, field, and neighborhood abstracts, regularly.
Devise, observe, and ferret out homes for rent by owner in South Egremont United States, vacation rental in South Egremont United States, and homes for rent by owner.
Design and espy Hampshire vacation rental, vacation rentals, apartment rentals Hampshire, and Hampshire Massachusetts rent houses.
Conceive and learn home rentals in North Pembroke United States and rental apartment.
Join our ski in/out classified ads, penthouse classified advertisements, secluded advertisements, and loft listings mailing list for real estate rentals in Hull Massachusetts, vacation rental in Hull Massachusetts, and homes for rent in Hull Massachusetts.
Conceive and invent for rent by owner homes Worcester Massachusetts, Worcester holiday rentals, and Worcester Massachusetts rental home.
Identify, identify, and relocate condo rentals in East Orleans, home rentals in East Orleans United States, and short term rentals.
Perceive, uncover, and disclose rental apartment in Whitman, Whitman apartments for rent, and homes for rent by owner in Whitman.
Recognize something else and special input in Hull and tab rental apartment in Hull Massachusetts.
Detect and discover homes for rent in Wayland and condos for rent Wayland United States.
|
|
