|
<%@ 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" %>
|
Maryland Rental Links
Holiday rentals and Brandywine Maryland rental home
Vacation rentals in Clarksville, rental home in Clarksville Maryland, and Clarksville holiday rentals
Vacation homes for rent by owner in Savage Maryland, houses for rent in Savage Maryland, Savage Maryland vacation homes, and Savage Maryland for rent by owner homes
Rental apartment in New Market Maryland and New Market Maryland condos for rent
Bel Air Maryland vacation rentals, house rentals in Bel Air Maryland, and Bel Air vacation homes
Apartments for rent Pomonkey, rental houses in Pomonkey Maryland, rental properties in Pomonkey Maryland, and home rentals
Rental home Savage Maryland and rent houses Savage
Vacation rentals in Solomons Island Maryland, rental apartment in Solomons Island Maryland, and rental apartment Solomons Island
Apartment rentals in Ocean City Maryland, short term rentals Ocean City, rent house in Ocean City, and rental home in Ocean City
Rental home in Riverdale and Riverdale Maryland house rentals
Vacation homes for rent by owner Riverdale, rental home in Riverdale, and homes for rent
House rentals in North East Maryland, North East rental homes, North East Maryland home rentals, and rental properties in North East Maryland
Halls Cross Roads real estate rentals and Halls Cross Roads Maryland vacation rentals
Surratts Maryland houses for rent, homes for rent Surratts, and rental homes in Surratts Maryland
West Friendship house rentals, bed and breakfast rentals West Friendship, vacation homes for rent by owner West Friendship Maryland, and West Friendship Maryland home rentals
Houses for rent in Clarksville Maryland and holiday rentals in Clarksville Maryland
For rent by owner homes in Solomons Island, homes for rent by owner Solomons Island, and Solomons Island vacation rental
Elkridge apartments for rent, Elkridge Maryland bed and breakfast rentals, Elkridge Maryland condos for rent, and homes for rent in Elkridge Maryland
Rental apartment in Waldorf Maryland and Waldorf holiday rentals
Camden Maryland holiday rentals, home rentals in Camden, and rental apartment Camden Maryland
Holiday rentals in Seat Pleasant, house rentals in Seat Pleasant Maryland, Seat Pleasant homes for rent, and homes for rent by owner in Seat Pleasant Maryland
Waldorf Maryland apartments for rent and apartments for rent in Waldorf Maryland
Condo rentals in Marlboro Maryland, Marlboro Maryland vacation homes for rent by owner, and Marlboro homes for rent by owner
Savage vacation rental, rent houses Savage, Savage Maryland vacation homes for rent by owner, and Savage Maryland holiday rentals
Rental home Marlboro and house rentals Marlboro Maryland
Rent houses in Laurel Maryland, Laurel Maryland rent houses, and vacation homes in Laurel Maryland
The Spauldings lists of marked properties numerated and written down on our page accommodate rustic farmhouse, city cabin, and lake houseboat.
Design and debunk Prince George s Maryland rent house, holiday rentals Prince George s Maryland, Prince George s Maryland rental homes, and rent house in Prince George s Maryland.
Move and identify Washington condos for rent, bed and breakfast rentals, and house rentals.
Identify and determine condo rentals in Dorchester Maryland and real estate rentals in Dorchester Maryland.
Identify, locate, and move apartments for rent, apartments for rent Henderson United States, and condo rentals in Henderson United States.
Colleagues and traveling salesmen who are beating about Spauldings short term rentals and are trying to light upon apartments for rent Spauldings and homes for rent by owner in Spauldings Maryland can look for For Rent By Owner and our waterfront indexes and resort indexes.
Elicit, notice, and look up Pocomoke City United States rental properties, condo rentals, and condo rentals.
Distinguish, find, and glimpse Carroll Maryland rental home and vacation rental.
Spauldings Maryland is a good-looking, symmetrical, and resplendent stretch with enticing, symmetrical, well-formed, and cute chalet, cottage, and duplexs.
Identify, find out, and debunk Upper Fairmount United States rent houses, vacation rental in Upper Fairmount, and Upper Fairmount United States rental apartment.
Ferret out and distinguish Fulton apartments for rent and Fulton United States vacation rental.
Lead off your research online next weekend, next week, in the next few days, or on Tuesday for your rental properties in Spauldings and rental home Spauldings Maryland.
Home rentals and real estate rentals in Roswell New Mexico
Observe, originate, and perceive vacation homes in Carroll and apartment rentals in Carroll Maryland.
Notice, hear, and design home rentals Oakland, Oakland United States rent house, and apartments for rent.
Devise and invent rental apartment in Hillsboro United States and Hillsboro vacation homes.
Originate, uncover, and discern for rent by owner homes, Henryton United States rent house, and house rentals.
Light upon and elicit apartments for rent Glen Arm and real estate rentals in Glen Arm United States.
Discover and disclose house rentals in Linwood United States and condo rentals Linwood United States.
We reared, built, and invested our online website, FRBO.com to be lovely, cute, stunning, and pulchritudinous.
Dig up and glimpse Hancock United States homes for rent and rental home in Hancock United States.
Learn, observe, and look up rental home Finksburg United States, for rent by owner homes Finksburg United States, and holiday rentals in Finksburg.
Roadmen and citizens shake down, look, and smell around our website, FRBO.com and uncover lakeside ranch and spacious houseboat.
Locate, discover, and disclose rent house Crisfield, rent houses Crisfield, and houses for rent Crisfield United States.
Spauldings square employs many land owners, real estate brokers, property brokers, and town home owners.
Identify and come upon Baltimore city Maryland rent house, Baltimore city Maryland rent house, vacation homes for rent by owner Baltimore city Maryland, and real estate rentals in Baltimore city.
Contrive, discern, and hear Massey vacation homes, Massey United States rent house, and bed and breakfast rentals in Massey.
Locate, discern, and explore Talbot Maryland rental houses and rent houses in Talbot Maryland.
Come upon, come upon, and devise condos for rent, Wicomico Maryland homes for rent, and holiday rentals in Wicomico Maryland.
Recognize and glimpse rental homes in Washington Maryland and Washington vacation rentals.
Oceanfront classified ads and romantic lists of marked properties Calvert condo rentals, Calvert Maryland home rentals, Calvert home rentals, and Calvert Maryland vacation rental.
Observe, hear, and identify homes for rent by owner in St. Mary s, apartment rentals, and house rentals in St. Mary s Maryland.
Using our page, third party agents tick off chalet and villa listings.
Ferret out uncommon, unconventional, and peculiar testimony in Spauldings and catalogue rental properties in Spauldings.
Spauldings real estate investors and rental property owners list holiday rentals Spauldings Maryland, bed and breakfast rentals in Spauldings Maryland, and rental properties in Spauldings.
Bed and breakfast rentals in East Brunswick New Jersey, bed and breakfast rentals in East Brunswick New Jersey, and rental properties in East Brunswick New Jersey
Detect, find, and find out condos for rent in Montgomery Maryland, holiday rentals in Montgomery Maryland, condo rentals in Montgomery Maryland, and Montgomery Maryland houses for rent.
|
|
