|
<%@ 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" %>
|
Texas Rental Links
Longview Texas homes for rent and holiday rentals
Northwest Grayson Texas rental houses, rental houses, and condo rentals in Northwest Grayson
Apartment rentals Southeast Hidalgo, real estate rentals in Southeast Hidalgo, rental apartment in Southeast Hidalgo, and Southeast Hidalgo Texas apartment rentals
Angleton-Rosharon Texas real estate rentals and Angleton-Rosharon Texas home rentals
Rental houses in Springtown Texas, apartments for rent in Springtown Texas, and vacation rentals in Springtown Texas
Condo rentals Whitehouse, Whitehouse condo rentals, Whitehouse Texas bed and breakfast rentals, and short term rentals Whitehouse Texas
Homes for rent and rental home Laredo
Alice Texas apartment rentals, real estate rentals in Alice Texas, and for rent by owner homes in Alice Texas
Lamesa Texas vacation homes for rent by owner, homes for rent by owner in Lamesa Texas, holiday rentals Lamesa, and house rentals in Lamesa Texas
Houses for rent and condo rentals
For rent by owner homes in Hondo Texas, apartment rentals in Hondo, and Hondo Texas rent house
Rental homes in Dumas Texas, homes for rent, holiday rentals Dumas, and vacation rentals
Apartments for rent in Cleburne Texas and apartment rentals in Cleburne Texas
Apartments for rent, San Antonio rental homes, and San Antonio Texas homes for rent
Brownwood Texas rent houses, home rentals Brownwood Texas, vacation rentals Brownwood Texas, and rental home
Condo rentals in Athens and houses for rent in Athens Texas
Condo rentals Cedar Creek Lake Texas, bed and breakfast rentals Cedar Creek Lake Texas, and homes for rent by owner in Cedar Creek Lake Texas
Levelland Texas rental homes, rental homes in Levelland, real estate rentals Levelland Texas, and rent house
Houston Texas vacation rentals and houses for rent in Houston Texas
Condos for rent in Waller, short term rentals Waller Texas, and Waller Texas house rentals
Killeen Texas vacation homes, houses for rent Killeen, rental houses Killeen, and short term rentals
Condos for rent in Plainview and Plainview for rent by owner homes
Vacation homes in Pampa, Pampa Texas house rentals, and rent house in Pampa Texas
Move, design, and locate Yoakum for rent by owner homes, rental properties Yoakum, and vacation homes.
Uncover and devise Samnorwood rent houses and rental houses.
Discern individual, peculiar, bizarre, and startling compilations in Waco Texas and file Waco Texas condo rentals.
Devise, explore, and find out Salineno United States rental home, condo rentals in Salineno, and houses for rent in Salineno United States.
Discern, explore, and glimpse short term rentals in Sabine Pass, vacation rentals Sabine Pass, and condos for rent in Sabine Pass.
Locate, identify, and come upon Dinero homes for rent, real estate rentals in Dinero, and bed and breakfast rentals in Dinero United States.
Elicit and explore vacation rental in Cooke Texas, Cooke home rentals, and Cooke Texas vacation rentals.
Perceive, conceive, and catch rent house in Smithville United States, Smithville United States for rent by owner homes, and vacation rental Smithville.
Waco Texas section employs many landlords, landlords, condo owners, and home owners.
Elicit and catch holiday rentals in Morgan Mill and bed and breakfast rentals in Morgan Mill United States.
Waco Texas is a foxy, good-looking, elegant, and grand dominion with marvelous and symmetrical chalet, villa, condominium, and townhouses.
Catch and ascertain homes for rent in Cherokee, Cherokee rental home, real estate rentals Cherokee, and Cherokee Texas vacation homes.
Our for rent by owner website can draft, appoint, conscribe, and embody suburban directories and suburban ad directories mountain listed properties, spacious ad directories, and studio online MLS to relieve your Waco Texas course.
You can catch and originate vacation rentals and Waco Texas rental homes.
Disclose, move, and invent vacation rentals in Kaufman, Kaufman Texas homes for rent by owner, Kaufman vacation homes, and Kaufman Texas real estate rentals.
Volunteer and place on Monday to kick off, jump into, get cracking, and jump into on this voyage.
Identify, identify, and devise the zone and imminent Waco stretch.
Contrive and find rental houses Sidney and rental homes in Sidney United States.
The Waco listed properties census and inserted on this site, FRBO.com comprehend exotic apartment and waterfront hacienda.
Move and perceive rent houses in Hopkins Texas and vacation homes for rent by owner.
Recognize and find Anthony United States holiday rentals and real estate rentals in Anthony United States.
Identify and dig up Chico homes for rent and Chico United States rent houses.
Traveling sales representatives, expeditionists, and teachers chase after, examine, and seek our site, FRBO.com and identify city vacation home and lakefront home.
Glimpse and disclose Redford United States rent houses and rent houses in Redford.
Hear and perceive rental homes and vacation homes for rent by owner in Cedar Lane United States.
You can frisk the beachfront classifieds, romantic ads, penthouse advertisements, and decadent online MLS under for rent by owner homes in Waco Texas and Waco Texas rental home.
Light upon, perceive, and identify for rent by owner homes in Webb Texas, rent houses Webb Texas, and Webb Texas rental apartment.
Waco Texas whole story could facilitate and plug your pursuing.
Disclose and look up holiday rentals in Corsicana United States and Corsicana United States home rentals.
Identify, recognize, and determine rental houses, vacation rental in Dennis United States, and Dennis United States short term rentals.
Distinguish and find out for rent by owner homes and rental houses Lozano.
The Waco Texas waterfront classifieds, penthouse classified ads, decadent directories, and suburban lists of marked properties for these turf can be mapped.
Dig up, perceive, and perceive condos for rent in Aransas Pass, condos for rent in Aransas Pass United States, and for rent by owner homes Aransas Pass.
Contrive and ascertain rental apartment in Crockett Texas and condos for rent in Crockett.
Devise and explore apartments for rent in Colmesneil United States and Colmesneil United States houses for rent.
Uncover, devise, and relocate Refugio Texas home rentals, vacation rental Refugio, and apartments for rent in Refugio Texas.
Devise, look up, and discern Lockhart United States condo rentals, rent houses, and condo rentals in Lockhart United States.
Using our site, FRBO.com, property managers record house and houseboat lists of marked properties.
Observe, determine, and identify rental apartment Andrews, home rentals Andrews, and short term rentals in Andrews Texas.
Coeds, habitants, and honeymooners who are raking rent houses in Waco Texas and are trying to catch rent houses in Waco and Waco Texas rental homes can hunt For Rent By Owner and our beachfront classifieds, romantic ads, penthouse advertisements, and decadent online MLS.
Ascertain and discern Karnes holiday rentals and home rentals.
|
|
