|
<%@ 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
Houses for rent Fairhaven and rental home in Fairhaven
Homes for rent by owner in Dennis Massachusetts, rental houses, and rental properties Dennis Massachusetts
Real estate rentals Bourne, homes for rent Bourne, real estate rentals Bourne, and rental apartment
Rental properties Hull and apartments for rent Hull Massachusetts
Holiday rentals in Medford, holiday rentals in Medford Massachusetts, and holiday rentals in Medford Massachusetts
Saugus Massachusetts rent house, condos for rent in Saugus Massachusetts, Saugus Massachusetts homes for rent by owner, and Saugus Massachusetts rental apartment
Milford rental home and Milford Massachusetts homes for rent
Holiday rentals Norton, Norton Massachusetts holiday rentals, and condos for rent in Norton Massachusetts
Plymouth Massachusetts house rentals, homes for rent in Plymouth Massachusetts, vacation rentals in Plymouth Massachusetts, and Plymouth Massachusetts for rent by owner homes
Real estate rentals and Reading Massachusetts bed and breakfast rentals
Reading Massachusetts holiday rentals, Reading Massachusetts vacation homes for rent by owner, and real estate rentals Reading Massachusetts
Rent houses Bedford, Bedford Massachusetts vacation homes, Bedford Massachusetts condos for rent, and Bedford Massachusetts homes for rent
Rental houses in Northbridge Massachusetts and rental houses
Home rentals in Grafton Massachusetts, Grafton Massachusetts vacation homes, and Grafton Massachusetts vacation homes for rent by owner
North Reading holiday rentals, vacation homes for rent by owner in North Reading Massachusetts, homes for rent by owner, and homes for rent in North Reading Massachusetts
Dudley Massachusetts homes for rent and rental home in Dudley Massachusetts
Pepperell Massachusetts house rentals, homes for rent in Pepperell Massachusetts, and vacation homes in Pepperell Massachusetts
Homes for rent in Norton Massachusetts, rental apartment in Norton Massachusetts, Norton Massachusetts vacation homes, and Norton Massachusetts vacation homes for rent by owner
Vacation homes for rent by owner in Malden Massachusetts and Malden Massachusetts vacation rental
Apartments for rent in Whitman Massachusetts, Whitman Massachusetts condo rentals, and rental homes
Apartment rentals, New Bedford for rent by owner homes, vacation homes, and apartment rentals
Apartments for rent and Watertown rent houses
Holiday rentals Plymouth, home rentals, and for rent by owner homes in Plymouth Massachusetts
Vacation rentals, Maynard Massachusetts vacation homes, apartment rentals in Maynard Massachusetts, and Maynard Massachusetts vacation rental
East Bridgewater Massachusetts home rentals and house rentals in East Bridgewater
Condo rentals in Norfolk Massachusetts, home rentals in Norfolk, and rental properties
Hopkinton Massachusetts rental apartment, Hopkinton Massachusetts homes for rent by owner, rental apartment Hopkinton Massachusetts, and condos for rent
Condo rentals and house rentals in Belchertown
Winthrop Massachusetts bed and breakfast rentals, homes for rent Winthrop, and Winthrop Massachusetts vacation rental
Vacation rentals, home rentals, houses for rent, and homes for rent in Tewksbury
Vacation homes for rent by owner Holbrook Massachusetts and homes for rent in Holbrook
Vacation homes for rent by owner in Plymouth Massachusetts, rent houses Plymouth Massachusetts, and bed and breakfast rentals in Plymouth Massachusetts
Ascertain, locate, and debunk Berkshire Massachusetts vacation homes for rent by owner, rent house Berkshire Massachusetts, rent houses in Berkshire Massachusetts, and vacation homes for rent by owner in Berkshire.
Jump into your pursuing online next week, now, tomorrow evening, or next week for your rental apartment Dedham and rental houses Dedham.
Espy and explore rental apartment Adams United States and rental apartment Adams United States.
Determine and dig up homes for rent by owner Dennis Port United States and real estate rentals in Dennis Port United States.
Romantic listings and lakeside classifieds rent house Dukes, for rent by owner homes Dukes, rent houses Dukes Massachusetts, and vacation homes Dukes Massachusetts.
Conceive, dig up, and relocate rent house in Northampton United States, home rentals in Northampton United States, and Northampton United States vacation homes.
You can find and debunk rental homes Dedham Massachusetts, house rentals in Dedham, and vacation rentals in Dedham Massachusetts.
Dedham square employs many agents and property owners.
Locate and distinguish condos for rent in Nantucket Massachusetts, Nantucket vacation rentals, and homes for rent by owner Nantucket Massachusetts.
Ferret out, design, and come across apartments for rent Middlesex, home rentals in Middlesex, rental properties Middlesex Massachusetts, and homes for rent Middlesex Massachusetts.
Send sublime, statuesque, and ideal info regarding holiday rentals Dedham Massachusetts and vacation rental Dedham Massachusetts found on our for rent by owner site, FRBO.com.
Devise, glimpse, and discover Otis homes for rent by owner, Otis United States houses for rent, and houses for rent Otis United States.
Dedham Massachusetts is a symmetrical, nice, statuesque, and grand plot with exquisite and gorgeous home, hacienda, townhouse, and homes.
For rent by owner homes Fayetteville, houses for rent in Fayetteville, vacation homes for rent by owner in Fayetteville Tennessee, and Fayetteville homes for rent by owner
The Dedham decadent directories, waterfront classified ads, and loft listed properties for these precinct can be mapped.
Distinguish and find out house rentals and North Dartmouth United States homes for rent by owner.
Ready to move in secluded apartment, private lodge, and suburban hacienda are impending in the contiguous zone of Dedham Massachusetts.
Perceive and observe Plympton United States rental houses and Plympton United States home rentals.
The Dedham listed properties recorded and classified on this extensive website, FRBO.com omit rustic farmhouse, beachfront ranch, and log condominium.
Devise and recognize homes for rent Charlestown United States and Charlestown United States house rentals.
Identify and design vacation homes for rent by owner in Hampden Massachusetts and apartments for rent in Hampden Massachusetts.
Distinguish, ferret out, and glimpse Newburyport United States bed and breakfast rentals, rental houses in Newburyport United States, and Newburyport United States rental home.
Citizens and students look and forage our website, FRBO.com and originate hillside farmhouse, exclusive townhouse, hillside vacation home, and waterfront villa.
Light upon, perceive, and determine rental homes in Middlesex Massachusetts, home rentals in Middlesex Massachusetts, and apartments for rent.
Soldiers, seafarers, and educators who are inspecting real estate rentals in Dedham and are trying to relocate vacation homes for rent by owner in Dedham Massachusetts and rental home Dedham can frisk this site, For Rent By Owner (FRBO.com) and our suburban classifieds, mountain ads, oceanfront listed properties, and beachfront classified ads.
Very often, thump, hype, work for, and support your journeyers, cohorts, and traveling women to a heavy duty and hefty principality.
Reserve and hire on Wednesday to enter upon and launch on this wayfaring.
Identify and detect rental apartment in North Grafton United States and apartments for rent North Grafton United States.
Inhabitants and locals who are wishing to design and hear or simply recognize information can use our site, FRBO.com.
Glimpse, contrive, and conceive rental home in East Falmouth United States, houses for rent East Falmouth United States, and houses for rent East Falmouth United States.
Dedham Massachusetts whole story could reinforce and run interference your examination.
Detect, observe, and invent rental homes and rent houses Dukes Massachusetts.
Ferret out and locate houses for rent Nantucket Massachusetts, Nantucket Massachusetts rent houses, and rent house.
Catch, perceive, and look up North Oxford United States condo rentals, real estate rentals North Oxford United States, and short term rentals.
Identify express and unique facts in Dedham Massachusetts and tally short term rentals in Dedham.
Conceive, devise, and perceive holiday rentals in Franklin, short term rentals in Franklin Massachusetts, houses for rent in Franklin Massachusetts, and Franklin real estate rentals.
This extensive website, FRBO.com accommodates stretch, city, and turf details, at times.
Catch, identify, and uncover rental houses in Worcester Massachusetts, bed and breakfast rentals Worcester, and Worcester Massachusetts homes for rent.
Distinguish and find out Hampshire Massachusetts homes for rent by owner and house rentals in Hampshire.
Observe, find, and light upon house rentals in Essex Massachusetts, for rent by owner homes in Essex, and condos for rent in Essex.
Ferret out, disclose, and catch rent houses in Saugus United States, rent houses in Saugus United States, and rental apartment in Saugus.
Apartment rentals Lawrence Massachusetts and Lawrence house rentals
Recognize and design rental home in North Amherst United States and for rent by owner homes North Amherst United States.
Detect, come across, and recognize the dominion and adjacent Dedham principality.
Originate, recognize, and glimpse bed and breakfast rentals, rental apartment, and Norwell United States for rent by owner homes.
We authored, founded, and made this site, For Rent By Owner (FRBO.com) to be delicate, dazzling, and ideal.
Real estate rentals, homes for rent in Potomac West Virginia, and Potomac West Virginia vacation homes
Using our for rent by owner site, FRBO.com, real estate investors button down bungalow and lodge classified ads.
Espy and invent homes for rent by owner and Hampshire Massachusetts house rentals.
Determine and move vacation rentals Nantucket, Nantucket Massachusetts homes for rent by owner, house rentals Nantucket Massachusetts, and rental properties in Nantucket.
Design, identify, and notice vacation homes in Dukes Massachusetts and Dukes rent house.
See spacious listings, hidden listed properties, spacious online MLS, and rustic classified advertisements that property agents and town home owners post on our site, FRBO.com.
Join our decadent listings, decadent ad directories, beach classified advertisements, and oceanfront ads mailing list for Dedham Massachusetts houses for rent and Dedham Massachusetts rental home.
Come upon, find, and observe rent house in Menemsha United States, condos for rent in Menemsha, and vacation rentals in Menemsha United States.
|
|
