Error: ALTER TABLE propData2 ADD Matrix_Unique_ID varchar(255)
Duplicate column name 'Matrix_Unique_ID'Error: ALTER TABLE propData2 ADD MatrixModifiedDT varchar(255)
Duplicate column name 'MatrixModifiedDT'Error: ALTER TABLE propData2 ADD MLSNumber varchar(255)
Duplicate column name 'MLSNumber'Error: ALTER TABLE propData2 ADD ListAgentFullName varchar(255)
Duplicate column name 'ListAgentFullName'Error: ALTER TABLE propData2 ADD ListOfficeName varchar(255)
Duplicate column name 'ListOfficeName'Error: ALTER TABLE propData2 ADD SellingAgentFullName varchar(255)
Duplicate column name 'SellingAgentFullName'Error: ALTER TABLE propData2 ADD SellingOfficeName varchar(255)
Duplicate column name 'SellingOfficeName'Error: ALTER TABLE propData2 ADD Latitude varchar(255)
Duplicate column name 'Latitude'Error: ALTER TABLE propData2 ADD Longitude varchar(255)
Duplicate column name 'Longitude'Error: ALTER TABLE propData2 ADD PhotoCount varchar(255)
Duplicate column name 'PhotoCount'Error: ALTER TABLE propData2 ADD PostalCode varchar(255)
Duplicate column name 'PostalCode'Error: ALTER TABLE propData2 ADD RoomCount varchar(255)
Duplicate column name 'RoomCount'Error: ALTER TABLE propData2 ADD ListPrice varchar(255)
Duplicate column name 'ListPrice'Error: ALTER TABLE propData2 ADD Status varchar(255)
Duplicate column name 'Status'Error: ALTER TABLE propData2 ADD StreetName varchar(255)
Duplicate column name 'StreetName'Error: ALTER TABLE propData2 ADD StreetNumber varchar(255)
Duplicate column name 'StreetNumber'Error: ALTER TABLE propData2 ADD StreetSuffix varchar(255)
Duplicate column name 'StreetSuffix'Error: ALTER TABLE propData2 ADD City varchar(255)
Duplicate column name 'City'Error: ALTER TABLE propData2 ADD BathsFull varchar(255)
Duplicate column name 'BathsFull'Error: ALTER TABLE propData2 ADD BathsHalf varchar(255)
Duplicate column name 'BathsHalf'Error: ALTER TABLE propData2 ADD BedsTotal varchar(255)
Duplicate column name 'BedsTotal'Error: ALTER TABLE propData2 ADD SqFtTotal varchar(255)
Duplicate column name 'SqFtTotal'Error: ALTER TABLE propData2 ADD PropertyType varchar(255)
Duplicate column name 'PropertyType'Error: ALTER TABLE propData2 ADD PublicRemarks varchar(255)
Duplicate column name 'PublicRemarks'Error: ALTER TABLE propData2 ADD Acres varchar(255)
Duplicate column name 'Acres'Error: ALTER TABLE propData2 ADD Area varchar(255)
Duplicate column name 'Area'Error: ALTER TABLE propData2 ADD BuilderName varchar(255)
Duplicate column name 'BuilderName'Error: ALTER TABLE propData2 ADD BuildingStories varchar(255)
Duplicate column name 'BuildingStories'Error: ALTER TABLE propData2 ADD Connections varchar(255)
Duplicate column name 'Connections'Error: ALTER TABLE propData2 ADD DaysOnMarketDisp varchar(255)
Duplicate column name 'DaysOnMarketDisp'Error: ALTER TABLE propData2 ADD Disclosures varchar(255)
Duplicate column name 'Disclosures'Error: ALTER TABLE propData2 ADD Dishwasher varchar(255)
Duplicate column name 'Dishwasher'Error: ALTER TABLE propData2 ADD FireplaceDescription varchar(255)
Duplicate column name 'FireplaceDescription'Error: ALTER TABLE propData2 ADD FireplacesNumber varchar(255)
Duplicate column name 'FireplacesNumber'Error: ALTER TABLE propData2 ADD GeoMarketArea varchar(255)
Duplicate column name 'GeoMarketArea'Error: ALTER TABLE propData2 ADD HeatSystem varchar(255)
Duplicate column name 'HeatSystem'Error: ALTER TABLE propData2 ADD HOAMandatory varchar(255)
Duplicate column name 'HOAMandatory'Error: ALTER TABLE propData2 ADD Legal varchar(255)
Duplicate column name 'Legal'Error: ALTER TABLE propData2 ADD LotDesciption varchar(255)
Duplicate column name 'LotDesciption'Error: ALTER TABLE propData2 ADD LotSize varchar(255)
Duplicate column name 'LotSize'Error: ALTER TABLE propData2 ADD LotSizeSource varchar(255)
Duplicate column name 'LotSizeSource'Error: ALTER TABLE propData2 ADD MaintenanceFeeYesNo varchar(255)
Duplicate column name 'MaintenanceFeeYesNo'Error: ALTER TABLE propData2 ADD MaintFeeAmt varchar(255)
Duplicate column name 'MaintFeeAmt'Error: ALTER TABLE propData2 ADD NewConstruction varchar(255)
Duplicate column name 'NewConstruction'Error: ALTER TABLE propData2 ADD NewConstructionDesc varchar(255)
Duplicate column name 'NewConstructionDesc'Error: ALTER TABLE propData2 ADD NoOfGarageCap varchar(255)
Duplicate column name 'NoOfGarageCap'Error: ALTER TABLE propData2 ADD OvenType varchar(255)
Duplicate column name 'OvenType'Error: ALTER TABLE propData2 ADD PoolPrivate varchar(255)
Duplicate column name 'PoolPrivate'Error: ALTER TABLE propData2 ADD PoolPrivateDesc varchar(255)
Duplicate column name 'PoolPrivateDesc'Error: ALTER TABLE propData2 ADD Range varchar(255)
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Range varchar(255)' at line 1Error: ALTER TABLE propData2 ADD RangeType varchar(255)
Duplicate column name 'RangeType'Error: ALTER TABLE propData2 ADD Refrigerator varchar(255)
Duplicate column name 'Refrigerator'Error: ALTER TABLE propData2 ADD Roof varchar(255)
Duplicate column name 'Roof'Error: ALTER TABLE propData2 ADD SchoolDistrict varchar(255)
Duplicate column name 'SchoolDistrict'Error: ALTER TABLE propData2 ADD SchoolElementary varchar(255)
Duplicate column name 'SchoolElementary'Error: ALTER TABLE propData2 ADD SchoolHigh varchar(255)
Duplicate column name 'SchoolHigh'Error: ALTER TABLE propData2 ADD SchoolMiddle varchar(255)
Duplicate column name 'SchoolMiddle'Error: ALTER TABLE propData2 ADD ShowInstructions varchar(255)
Duplicate column name 'ShowInstructions'Error: ALTER TABLE propData2 ADD SqFtSource varchar(255)
Duplicate column name 'SqFtSource'Error: ALTER TABLE propData2 ADD Stories varchar(255)
Duplicate column name 'Stories'Error: ALTER TABLE propData2 ADD Style varchar(255)
Duplicate column name 'Style'Error: ALTER TABLE propData2 ADD Subdivision varchar(255)
Duplicate column name 'Subdivision'Error: ALTER TABLE propData2 ADD TaxAmount varchar(255)
Duplicate column name 'TaxAmount'Error: ALTER TABLE propData2 ADD TaxRate varchar(255)
Duplicate column name 'TaxRate'Error: ALTER TABLE propData2 ADD WaterSewer varchar(255)
Duplicate column name 'WaterSewer'Error: ALTER TABLE propData2 ADD YearBuilt varchar(255)
Duplicate column name 'YearBuilt'Error: ALTER TABLE propData2 ADD YearBuiltSrc varchar(255)
Duplicate column name 'YearBuiltSrc'UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T19:45:03.137' ,`MLSNumber` = '73189315' ,`ListAgentFullName` = 'Currie Luedecke' ,`ListOfficeName` = 'Leyco Real Estate' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.705209' ,`Longitude` = '-96.543199' ,`PhotoCount` = '35' ,`PostalCode` = '78934' ,`RoomCount` = '6' ,`ListPrice` = '575000.00' ,`Status` = 'Active' ,`StreetName` = 'Live Oak' ,`StreetNumber` = '1204' ,`StreetSuffix` = 'Street' ,`City` = 'Columbus' ,`BathsFull` = '3' ,`BathsHalf` = '0' ,`BedsTotal` = '6' ,`SqFtTotal` = '4367' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This sprawling estate offers a timeless design admired by all who drive by! Being that only two families have owned the home since it was built in 1937, it is an understatement to say that it has been meticulously maintained and a labor of love. The home offers multiple living and dining spaces making it ideal for those that like to entertain. It has 6 bedrooms but one could easily be turned into a game room or media room due to its size and layout. The large corner lot is just blocks from the historic downtown area, the public library and the elementary school. Room dimensions are estimated.' ,`Acres` = '0.416' ,`Area` = '56' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'BLK 48 LT S-1-3 COLUMBUS HOUSE & BLDG' ,`LotDesciption` = 'Corner' ,`LotSize` = '' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = '' ,`Refrigerator` = '' ,`Roof` = 'Slate' ,`SchoolDistrict` = '188 - Columbus' ,`SchoolElementary` = 'COLUMBUS ELEMENTARY SCHOOL' ,`SchoolHigh` = 'COLUMBUS HIGH SCHOOL' ,`SchoolMiddle` = 'COLUMBUS JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'English' ,`Subdivision` = 'Columbus' ,`TaxAmount` = '5851' ,`TaxRate` = '1.8359' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1937' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103683' WHERE `Matrix_Unique_ID` = '203657033' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T19:03:00.783' ,`MLSNumber` = '15461475' ,`ListAgentFullName` = 'Lou Rosas' ,`ListOfficeName` = 'RE/MAX Real Estate Assoc.' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.621747' ,`Longitude` = '-95.237584' ,`PhotoCount` = '46' ,`PostalCode` = '77075' ,`RoomCount` = '7' ,`ListPrice` = '450000.00' ,`Status` = 'Active' ,`StreetName` = 'Lizette' ,`StreetNumber` = '10015' ,`StreetSuffix` = 'Court' ,`City` = 'Houston' ,`BathsFull` = '3' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2780' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This 4 Bedroom 2 Full and 1 Half Bath home was built in 2005 and has been remodeled (new doors, new doorknobs, new ceiling fans, crown molding, Primary Bedroom completely remodeled) - some of the added features are: a new stove and microwave, a New HVAC system with all new ducts installed in 2020 (and was set up with additional thick filters to protect persons with asthmatic issues), New floors (Travertine Tile on ground floor and wood on second floor). New Inground/Gunite fresh water Pool built in 2019, New Outdoor Kitchen - covered Patio, outdoor Fireplace, a Full Outdoor Restroom for Pool and Parties - built in 2019. New Gas Stove and Microwave. The garage has plenty of storage cabinets' ,`Acres` = '0.1408' ,`Area` = '3' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Southbelt/Ellington' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'LT 7 BLK 2 SOUTH UNIVERSITY PLACE' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '6132' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '285' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'Gunite,In Ground' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '41 - Pasadena' ,`SchoolElementary` = 'HANCOCK ELEMENTARY SCHOOL (PASADENA)' ,`SchoolHigh` = 'SOUTH HOUSTON HIGH SCHOOL' ,`SchoolMiddle` = 'BEVERLYHILLS INTERMEDIATE SCHOOL' ,`ShowInstructions` = 'Accompany,Appointment Required,No Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'South University Place' ,`TaxAmount` = '6777' ,`TaxRate` = '2.6863' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2005' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103683' WHERE `Matrix_Unique_ID` = '209741830' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T19:57:14.727' ,`MLSNumber` = '91574786' ,`ListAgentFullName` = 'Lynn Juravich' ,`ListOfficeName` = 'Keller Williams Realty - Memor' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.805571' ,`Longitude` = '-95.514103' ,`PhotoCount` = '10' ,`PostalCode` = '77080' ,`RoomCount` = '9' ,`ListPrice` = '600000.00' ,`Status` = 'Active' ,`StreetName` = 'Western' ,`StreetNumber` = '9110' ,`StreetSuffix` = 'Drive' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '4' ,`SqFtTotal` = '1514' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Great opportunity for rehab and or redevelopment possible room for 4+ townhomes. Large ranch style home on oversize lot. You have plenty of room for a large pool. 4 Bedrooms and 2 baths with patio. Fresh paint, recent roof, wood floor resurfaced. There is also a possibility for redevelopment, as there is a lot of activity in the area. Huge back yard for your four legged buddy.' ,`Acres` = '' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'No Disclosures' ,`Dishwasher` = '0' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '0' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 8 BLK 1 HOLLY OAKS' ,`LotDesciption` = 'Corner,Subdivision Lot' ,`LotSize` = '14096' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'SPRING BRANCH ELEMENTARY SCHOOL' ,`SchoolHigh` = 'NORTHBROOK HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING WOODS MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch,Traditional' ,`Subdivision` = 'Holly Oaks' ,`TaxAmount` = '5325' ,`TaxRate` = '2.73102' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1956' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103683' WHERE `Matrix_Unique_ID` = '210051275' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T19:12:47.780' ,`MLSNumber` = '17775623' ,`ListAgentFullName` = 'David Montalvo' ,`ListOfficeName` = 'Homelister, Inc' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.789775' ,`Longitude` = '-95.535846' ,`PhotoCount` = '45' ,`PostalCode` = '77055' ,`RoomCount` = '5' ,`ListPrice` = '455000.00' ,`Status` = 'Active' ,`StreetName` = 'Larston' ,`StreetNumber` = '9806' ,`StreetSuffix` = 'Street' ,`City` = 'Houston' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1837' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Location location Eatery, Shopping mall, HEB, Hospital. Beautiful curve appeal w/Ranch Style home raised long front porch with white pillars overlooking the pride of ownership garden flowers/lawn. Step inside to a spacious and open floor plan where family and friends can gather in several areas and still be together including the Chef of the home with it\'s Gas Stovetop and Glass Vent open to the rooms this wonderful Kitchen includes a large Walk in Pantry. In 2014 This home was gutted down to the studs including electrical and water lines replaced with Pex pipe with cutoff panel Inhouse Utility room. A Bonus Room off the dining area with French double doors leading to the large backyard w/room for a pool. The Master Bedroom is spacious with sitting area n walk in closet and combination Garden Tub/Shower with a large hamper built w/linen cabinet. 2 large bedrooms w/ample closets. 2014 Roof/ Exterior Brick n Hardi board. Too many updates to list come see this beautiful home.' ,`Acres` = '0.1928' ,`Area` = '24' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Gas Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Spring Branch' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'LT 18 BLK 6 SPRING BRANCH WOODS SEC 1' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '8400' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Gas Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '49 - Spring Branch' ,`SchoolElementary` = 'WOODVIEW ELEMENTARY SCHOOL' ,`SchoolHigh` = 'SPRING WOODS HIGH SCHOOL' ,`SchoolMiddle` = 'SPRING BRANCH MIDDLE SCHOOL (SPRING BRANCH)' ,`ShowInstructions` = 'Appointment Required,Leave Business Card,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Ranch' ,`Subdivision` = 'Spring Branch Woods' ,`TaxAmount` = '10370' ,`TaxRate` = '2.4415' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1960' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103683' WHERE `Matrix_Unique_ID` = '210666771' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T19:14:48.957' ,`MLSNumber` = '85356706' ,`ListAgentFullName` = 'Thai Truong' ,`ListOfficeName` = 'eXp Realty, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.588551' ,`Longitude` = '-95.576662' ,`PhotoCount` = '43' ,`PostalCode` = '77459' ,`RoomCount` = '10' ,`ListPrice` = '349500.00' ,`Status` = 'Active' ,`StreetName` = 'Oak Valley' ,`StreetNumber` = '4411' ,`StreetSuffix` = 'Drive' ,`City` = 'Missouri City' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2616' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Well maintained two-story home in highly desirable tree lined cul-de-sac street of Plantation Creek! Located just minutes from the HWY 6, this 4 bedroom 2 1/2 bath, 2610+ square feet home boast with open plan for entertaining and relaxing with friends and family. Kitchen and breakfast area are open to family room with fireplace. Wonderful formal living and dining room combination with wall of windows to bring in all that NATURAL light. Large primary bedroom suite includes dual vanities, separate shower, and garden tub. 3 secondary bedrooms and game room upstairs. Fantastic place for the outdoor living - well-manicured backyard with fruit trees. Wonderful covered patio deck for morning coffee and evening drinks (owner spent more than 30K on this deck). Storage shed stays with the house. Never Flooded. Call for appointment today before it’s gone.' ,`Acres` = '0.1386' ,`Area` = '29' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Mud,Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Missouri City Area' ,`HeatSystem` = 'Central Electric' ,`HOAMandatory` = '1' ,`Legal` = 'PLANTATION CREEK SEC 1, BLOCK 2, LOT 16' ,`LotDesciption` = 'Cul-De-Sac,Subdivision Lot' ,`LotSize` = '6039' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '812' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Freestanding Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '19 - Fort Bend' ,`SchoolElementary` = 'LEXINGTON CREEK ELEMENTARY SCHOOL' ,`SchoolHigh` = 'DULLES HIGH SCHOOL' ,`SchoolMiddle` = 'DULLES MIDDLE SCHOOL' ,`ShowInstructions` = 'Request Online Appointment,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Plantation Creek Sec 1' ,`TaxAmount` = '7242' ,`TaxRate` = '2.71' ,`WaterSewer` = 'Water District' ,`YearBuilt` = '1992' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103684' WHERE `Matrix_Unique_ID` = '210668276' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T20:28:35.987' ,`MLSNumber` = '77533811' ,`ListAgentFullName` = 'Adriane Taylor' ,`ListOfficeName` = 'Walzel Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '30.217313' ,`Longitude` = '-95.538085' ,`PhotoCount` = '30' ,`PostalCode` = '77382' ,`RoomCount` = '6' ,`ListPrice` = '375000.00' ,`Status` = 'Active' ,`StreetName` = 'Thistle Thorn' ,`StreetNumber` = '421' ,`StreetSuffix` = 'Drive' ,`City` = 'Spring' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '2' ,`SqFtTotal` = '1407' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Buy a lifestyle while residing in this gated community of Del Webb - The Woodlands! Enjoy the Resort Style Amenities found in this active adult 55+community! Outdoor amenities include Outdoor Pool, Tennis Courts, Pickleball Courts, & Bocce Ball Courts. Indoor amenities include Indoor Pool, Covered Clubhouse Patio, Ballroom w/Kitchen, Fitness Center, Aerobics Room, & a Great Meeting Space. This charming brick and stone exterior home is barely lived in and looking for its\' next new owner. Gleaming wood floors are found in all areas except bathrooms, which are ceramic tile. NO CARPET ANYWHERE. Tray ceilings and updated fans and light fixtures are found throughout. Professional landscaping can also be enjoyed while sitting in the front or back covered patios! Close proximity to a multitude of restaurants, grocery stores, and hospitals. PLUS very LOW PROPERTY TAXES TOO. What are you waiting for? Make this your next new home and enjoy all of the amenities and conveniences found here!' ,`Acres` = '0.1102' ,`Area` = '15' ,`BuilderName` = 'Pulte' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '' ,`GeoMarketArea` = 'Magnolia/1488 East' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'S402307 - DEL WEBB THE WOODLANDS 07, BLOCK 1, LOT 34' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '4800' ,`LotSizeSource` = 'Survey' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '3200' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '36 - Magnolia' ,`SchoolElementary` = 'TOM R. ELLISOR ELEMENTARY SCHOOL' ,`SchoolHigh` = 'MAGNOLIA HIGH SCHOOL' ,`SchoolMiddle` = 'BEAR BRANCH JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Controlled Access,Supra Keybox' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Del Webb The Woodlands' ,`TaxAmount` = '658' ,`TaxRate` = '1.8587' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2021' ,`YearBuiltSrc` = 'Builder' ,`rets_update_timestamp`='1675103684' WHERE `Matrix_Unique_ID` = '212254337' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T20:46:10.453' ,`MLSNumber` = '68511848' ,`ListAgentFullName` = 'Cathy Pugh' ,`ListOfficeName` = 'Emblem Properties' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '31.314151' ,`Longitude` = '-95.444981' ,`PhotoCount` = '44' ,`PostalCode` = '75835' ,`RoomCount` = '10' ,`ListPrice` = '389000.00' ,`Status` = 'Active' ,`StreetName` = 'Enchanted Estates' ,`StreetNumber` = '218' ,`StreetSuffix` = 'Drive' ,`City` = 'Crockett' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '3' ,`SqFtTotal` = '3182' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'This lovely home is located in the beautiful neighborhood of Enchanted Estates. It offers an open-concept floorplan with 2 beautiful living areas, a formal dining room, and a home office/study for a total of 3,182 sq. ft. \r\nThe kitchen is open to the breakfast area and family room. The primary bedroom is huge with a spa tub, separate shower, and 2 walk-in closets. The secondary bedrooms both have walk-in closets, providing great storage. The two living rooms provide excellent space for entertaining family and friends. The large family room has a Gas Heatilator Fireplace for those chilly winter days! A wonderful bonus for this home is the large back yard with a covered patio, storage building and a new fence! The utility room has a sink, plenty of cabinets and room for folding clothes. There is a half-bath convenient for guests! Come see this lovely home on a little over a quarter acre in a wonderful subdivision in Crockett... you will love it!' ,`Acres` = '0.279' ,`Area` = '41' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Washer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Gas Connections,Gaslog Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = 'Crockett Area' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'ENCHANTED ESTATES LOT 1 BLK 2 SEC C' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '12153' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '100' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Electric Oven,Single Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Electric Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '57 - Crockett' ,`SchoolElementary` = 'CROCKETT ELEMENTARY SCHOOL (CROCKETT)' ,`SchoolHigh` = 'CROCKETT HIGH SCHOOL (CROCKETT)' ,`SchoolMiddle` = 'CROCKETT JUNIOR HIGH SCHOOL (CROCKETT)' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,No Supra Keybox,Vacant/Unoccupied' ,`SqFtSource` = 'Appraisal' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Enchanted Estates' ,`TaxAmount` = '6623' ,`TaxRate` = '2.3627' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '2003' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103684' WHERE `Matrix_Unique_ID` = '214483215' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T19:50:21.633' ,`MLSNumber` = '25575301' ,`ListAgentFullName` = 'Alioune Ndiaye' ,`ListOfficeName` = 'Real Broker, LLC' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.544931' ,`Longitude` = '-95.706264' ,`PhotoCount` = '48' ,`PostalCode` = '77469' ,`RoomCount` = '4' ,`ListPrice` = '399949.00' ,`Status` = 'Active' ,`StreetName` = 'Mitre Peak' ,`StreetNumber` = '5822' ,`StreetSuffix` = 'Lane' ,`City` = 'Richmond' ,`BathsFull` = '2' ,`BathsHalf` = '1' ,`BedsTotal` = '4' ,`SqFtTotal` = '2854' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully, updated 2 story home on a quiet & HUGE oversized cul-de-sac lot! Enjoy being located within a secluded gated community with No back neighbors! Lots of upgrades went into this home such as this custom wrought iron metal railing, upgraded wood flooring throughout, upgraded shutters and solar shades, dual waterfall quartz countertops, upgraded shaker style cabinets and much more! Plenty of room for outdoor recreation + a stunning pool with detached garage. Four spacious bedrooms, all upstairs. This home also offers both formals + big family room and lovely updated kitchen! A great buy for someone looking for a place to call home for a very long time! Zoned to GRADE A+ ranked elementary, middle and high schools! Great proximity to the Grand Parkway and Highway 59!' ,`Acres` = '0.2899' ,`Area` = '30' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = '' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = '' ,`FireplacesNumber` = '2' ,`GeoMarketArea` = 'Fort Bend South/Richmond' ,`HeatSystem` = 'Central Electric,Central Gas' ,`HOAMandatory` = '1' ,`Legal` = 'CANYON GATE AT THE BRAZOS SEC 3, BLOCK 3, LOT 43' ,`LotDesciption` = 'Cul-De-Sac' ,`LotSize` = '12629' ,`LotSizeSource` = 'Appraisal District' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '1000' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = '' ,`PoolPrivate` = '1' ,`PoolPrivateDesc` = 'In Ground' ,`Range` = '' ,`RangeType` = 'Gas Cooktop' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '33 - Lamar Consolidated' ,`SchoolElementary` = 'WILLIAMS ELEMENTARY SCHOOL (LAMAR)' ,`SchoolHigh` = 'GEORGE RANCH HIGH SCHOOL' ,`SchoolMiddle` = 'RYON/READING JUNIOR HIGH SCHOOL' ,`ShowInstructions` = 'Appointment Required,Lockbox Front,Request Online Appointment' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '2' ,`Style` = 'Traditional' ,`Subdivision` = 'Canyon Gate At The Brazos Sec 3' ,`TaxAmount` = '7060' ,`TaxRate` = '2.6448' ,`WaterSewer` = 'Public Sewer,Public Water,Water District' ,`YearBuilt` = '2000' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103684' WHERE `Matrix_Unique_ID` = '214759182' --> Updated record success
UPDATE propData2 SET `MatrixModifiedDT` = '2023-01-04T20:53:42.777' ,`MLSNumber` = '80095620' ,`ListAgentFullName` = 'Heather Lange' ,`ListOfficeName` = 'RE/MAX One' ,`SellingAgentFullName` = '' ,`SellingOfficeName` = '' ,`Latitude` = '29.959344' ,`Longitude` = '-93.914269' ,`PhotoCount` = '36' ,`PostalCode` = '77619' ,`RoomCount` = '7' ,`ListPrice` = '260000.00' ,`Status` = 'Active' ,`StreetName` = 'Wilson' ,`StreetNumber` = '4551' ,`StreetSuffix` = 'Avenue' ,`City` = 'Groves' ,`BathsFull` = '2' ,`BathsHalf` = '0' ,`BedsTotal` = '3' ,`SqFtTotal` = '1801' ,`PropertyType` = 'Single-Family' ,`PublicRemarks` = 'Beautifully updated cottage in Port Neches-Groves ISD sitting on over 1/2 an acre! Open-concept den/dining/kitchen. Den + separate living room. Hard surface floors throughout. Spacious rooms. Kitchen with quartz counters and stainless double oven, microwave, dishwasher and fridge. Outdoors you have a two car detached garage with 2 car carport, two small metal shops and a shed.' ,`Acres` = '0.67' ,`Area` = '51' ,`BuilderName` = '' ,`BuildingStories` = '' ,`Connections` = 'Electric Dryer Connections,Gas Dryer Connections' ,`DaysOnMarketDisp` = '' ,`Disclosures` = 'Sellers Disclosure' ,`Dishwasher` = '1' ,`FireplaceDescription` = 'Wood Burning Fireplace' ,`FireplacesNumber` = '1' ,`GeoMarketArea` = '' ,`HeatSystem` = 'Central Gas' ,`HOAMandatory` = '0' ,`Legal` = 'Lot 6 & 7 all, BLK 2, Lee To Groves' ,`LotDesciption` = 'Subdivision Lot' ,`LotSize` = '' ,`LotSizeSource` = '' ,`MaintenanceFeeYesNo` = '' ,`MaintFeeAmt` = '' ,`NewConstruction` = '0' ,`NewConstructionDesc` = '' ,`NoOfGarageCap` = '2' ,`OvenType` = 'Double Oven' ,`PoolPrivate` = '0' ,`PoolPrivateDesc` = '' ,`Range` = '' ,`RangeType` = 'Gas Range' ,`Refrigerator` = '' ,`Roof` = 'Composition' ,`SchoolDistrict` = '233 - Port Neches-Groves' ,`SchoolElementary` = 'PORT NECHES ELEMENTARY SCHOOL' ,`SchoolHigh` = 'PORT NECHES-GROVES HIGH SCHOOL' ,`SchoolMiddle` = 'GROVES MIDDLE SCHOOL' ,`ShowInstructions` = 'Appointment Required' ,`SqFtSource` = 'Appraisal District' ,`Stories` = '1' ,`Style` = 'Traditional' ,`Subdivision` = 'Lee To Groves' ,`TaxAmount` = '' ,`TaxRate` = '' ,`WaterSewer` = 'Public Sewer,Public Water' ,`YearBuilt` = '1962' ,`YearBuiltSrc` = 'Appraisal District' ,`rets_update_timestamp`='1675103685' WHERE `Matrix_Unique_ID` = '214788652' --> Updated record success
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215360621','1675103685','215360621','2023-01-04T20:56:25.137','31467771','Cathy Nguyen','The Nguyens & Associates','','','29.995200','-95.154534','29','77346','4','319500.00','Active','Walden Forest','18519','Drive','Humble','2','1','4','2897','Single-Family','Remodeled two story home in the desirable Walden Villages of Lake Houston. Home sits on a lot with no back neighbors and stream view of Lake Houston. Inside entry foyer greets you with 22\' ceilings and open concept family room and dining room. 2 story gas fireplace in the living to the gas fireplace in the downstairs master are just a few of the unique features of this home. The master bedroom is a true owner\'s retreat with walls of windows, en-suite bathroom with his and her sinks, large separate soaking tub, and standing shower. Upstairs has 3 bedrooms and an updated secondary bathroom with double vanity. The home in the trees with space for all and tranquility. Come view all that this amazing home in Walden Villages has to offer.','0.2296','1','','','Electric Dryer Connections,Gas Dryer Connections,Washer Connections','','Sellers Disclosure','1','Gaslog Fireplace','2','Atascocita South','Central Electric','1','LT 8 BLK 8 GOLFERS VILLAGE WALDEN ON LAKE HOUSTON PH 1','Subdivision Lot','10000','Appraisal District','','365','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','29 - Humble','MAPLEBROOK ELEMENTARY SCHOOL','ATASCOCITA HIGH SCHOOL','ATASCOCITA MIDDLE SCHOOL','Appointment Required','Appraisal District','2','Traditional','Walden On Lake Houston Ph 01','5544','2.5885','Water District','1984','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','215634167','1675103685','215634167','2023-01-04T20:54:41.917','19229314','Amber Griffin','Coldwell Banker Realty','Nicole Freer','NICOLE FREER GROUP','29.942997','-95.565271','36','77064','6','250000.00','Pending Continue to Show','Marblemount','9514','Drive','Houston','2','0','3','1898','Single-Family','Fantastic, updated property tucked into a cul-de-sac street. The sellers have taken pride in the many updates including kitchen cabinets, granite counter tops, stove/ range, microwave, dishwasher, sink & garbage disposal. Updated Primary bathroom w/ synthetic marble countertop, vanity, double sinks, mirror, tub/ shower combo, & tile flooring. Updated second bath features steel tub / shower combo, vanity, granite counter, mirror and tile flooring. Recent interior doors & 3 exterior doors. (primary door is prior to 2019). Ceiling fans / lighting( except garage & attic), horizontal Pex piping in the attic, side fences, thermostat & condenser fan motor, & blown in insulation in the attic. Recent electrical outlets & switches. Fresh landscaping. Interior & Exterior have been freshly painted. Recent professional chimney inspection & cleaning. (Above updates from 2020 -2022 per seller). 90% of ductwork replaced in 2022, per seller. Roof (2019 per seller). Great Investment opportunity also!”','0.1469','10','','','Electric Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','Wood Burning Fireplace','1','Willowbrook South','Central Electric','1','LT 4 BLK 1 TURTLE LAKE SEC 1','Cul-De-Sac','6400','Appraisal District','','400','0','','2','Electric Oven','0','','','Electric Cooktop','','Composition','13 - Cypress-Fairbanks','FRANCONE ELEMENTARY SCHOOL','CYPRESS CREEK HIGH SCHOOL','CAMPBELL MIDDLE SCHOOL','Appointment Required,Supra Keybox','Appraisal District','1','Traditional','Turtle Lake Sec 01','5310','2.8087','Water District','1979','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216067749','1675103685','216067749','2023-01-04T20:58:26.800','63298379','Jineane Owen','JLA Realty','','','30.132594','-95.298597','31','77365','7','272500.00','Active','Woodsdale','18166','Court','Porter','2','0','3','1587','Single-Family','Come fall in love with this meticulously maintained single story home located in Cumberland Community. Primary suite has a sitting area with a large walk-in closet. This lovely kitchen features a raised bar which opens up to the dining and living room and easily flows to the back patio for outdoor entertaining. The fenced back yard off the living room has a replastered & tiled pool with a slide & back patio for summers out in the sun. The home offers a split floor plan with a home office at the front of the home. exterior paint (2021), HVAC (2020), Fence (2020), sprinkler system, pool pump (2021). NCISD Crippen Elementary school within the subdivision. Community pool, park, basketball court & walking trails. Easy access to 99 & Valley Ranch.','0.1377','40','','','Gas Dryer Connections,Washer Connections','','Mud,Sellers Disclosure','1','','','Porter/New Caney West','Central Gas','1','CUMBERLAND PHASE I, BLOCK 8, LOT 16','Cul-De-Sac','6000','Appraisal District','','540','0','','2','Gas Oven','1','In Ground','','Gas Cooktop','','Composition','39 - New Caney','ROBERT CRIPPEN ELEMENTARY SCHOOL','PORTER HIGH SCHOOL (NEW CANEY)','WHITE OAK MIDDLE SCHOOL (NEW CANEY)','Appointment Required','Appraisal District','1','Traditional','Cumberland Ph I','4766','2.7931','Public Sewer,Public Water','2001','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216070373','1675103685','216070373','2023-01-04T19:58:32.537','57873346','Hong Zhang','PRG, Realtors','','','29.692126','-95.602022','6','77072','8','250000.00','Active','Ashford','12555','River','Houston','2','1','3','1959','Single-Family','Beautiful 2-story home, 1958SQ,3beds,2baths. One of the largest home in subdivision. A great property for investor. Currently tenant occupied. Month by month, rent is $1600. Please do not disturb tenants.','0.0771','28','','','','','Sellers Disclosure','1','Gas Connections','1','Alief','Central Electric','1','LT 26 BLK 2 ASHFORD GARDENS','Patio Lot','3360','Appraisal District','','250','0','','2','','0','','','','','Composition','2 - Alief','LIESTMAN ELEMENTARY SCHOOL','AISD DRAW','KILLOUGH MIDDLE SCHOOL','Call Occupant','Appraisal District','2','Traditional','Ashford Gardens','5706','2.4411','Public Sewer,Public Water','2005','Appraisal District'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216074721','1675103685','216074721','2023-01-04T19:28:44.453','11879399','Matthew Guzman','RE/MAX Universal','','','29.451219','-95.300863','21','77511','10','399566.00','Active','Meritage','23503','Drive','Alvin','2','1','4','2558','Single-Family','CLICK ON SAMPLE 3D INTERACTIVE VIRTUAL TOUR!!! LAKE LOT!!! Beautiful 2 Story, The Haydock Floor Plan with 5 Bedroom, 3 1/2 Bath, with a 2 Car Garage. This floor plan boasts a Spacious OPEN CONCEPT with high ceilings and the Family Room, Kitchen, Breakfast Room, Formal Dining Room, and the Master Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms and a Flex Space. You will love the Kitchen with the plenty of cabinets and granite countertops with stainless steel appliances, and even a USB outlet. Don\'t miss all the recessed lighting throughout the home. Covered PATIO with fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Rheem® Whole House Tankless Gas Water Heater, Radiant Barrier, and Low E Windows that open to the inside of the home for cleaning. Martha’s Vineyard will offer residents two large lakes, playgrounds, and splash pad. Alvin ISD. Convenient to Hwy. 6, Hwy 288, and Beltway 8.','0.1791','5','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Alvin North','Central Gas','1','MARTHA\'S VINEYARD SEC 3 (A0230 HT&BRR) BLK 2 LOT 29','Subdivision Lot','7802','Appraisal District','','550','1','Never Lived In','2','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Accompany,Appointment Required,Leave Business Card','Builder','2','Traditional','Martha\'s Vineyard','2313','3.7074','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216074825','1675103685','216074825','2023-01-04T19:40:30.817','24302059','Matthew Guzman','RE/MAX Universal','','','29.453100','-95.298497','7','77511','11','414176.00','Active','Malbec','23519','Drive','Alvin','2','1','4','2576','Single-Family','CLICK ON SAMPLE 3D INTERACTIVE VIRTUAL TOUR!!! Welcome home to your beautiful Chester Floor Plan with 4 Bedrooms, 2 1/2 Baths, & a 3 CAR GARAGE. This floor plan boasts a spacious OPEN CONCEPT FLOOR PLAN. You will love the Kitchen with lots of cabinets and granite countertops with stainless steel appliances, and even a USB outlet. Don\'t miss all the recessed lighting throughout the home. COVERED PATIO & fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Wifi Programmable Thermostat, Pex Hot & Cold Water Lines, Radiant Barrier, Rheem® Whole House Tankless Gas Water Heater, and Vinyl Double Pane Low E Windows that open to the inside of the home for Cleaning. Martha’s Vineyard, located just northwest from the intersection of Highway 6 and CR-46. Spanning over 100 acres, the new development of Martha’s Vineyard will offer residents two large lakes, playgrounds, and splash pad. Convenient to Hwy. 6 and Beltway 8.','0.1791','5','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Alvin North','Central Gas','1','MARTHA\'S VINEYARD SEC 3 (A0230 HT&BRR) BLK 1 LOT 14','Subdivision Lot','7802','Appraisal District','','550','1','Never Lived In','3','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Leave Business Card','Builder','2','Traditional','Martha\'s Vineyard','1987','3.7074','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully
INSERT INTO `propData2` (`rets_server_id`,`rets_data_unique_id`,`rets_update_timestamp`,`Matrix_Unique_ID`,`MatrixModifiedDT`,`MLSNumber`,`ListAgentFullName`,`ListOfficeName`,`SellingAgentFullName`,`SellingOfficeName`,`Latitude`,`Longitude`,`PhotoCount`,`PostalCode`,`RoomCount`,`ListPrice`,`Status`,`StreetName`,`StreetNumber`,`StreetSuffix`,`City`,`BathsFull`,`BathsHalf`,`BedsTotal`,`SqFtTotal`,`PropertyType`,`PublicRemarks`,`Acres`,`Area`,`BuilderName`,`BuildingStories`,`Connections`,`DaysOnMarketDisp`,`Disclosures`,`Dishwasher`,`FireplaceDescription`,`FireplacesNumber`,`GeoMarketArea`,`HeatSystem`,`HOAMandatory`,`Legal`,`LotDesciption`,`LotSize`,`LotSizeSource`,`MaintenanceFeeYesNo`,`MaintFeeAmt`,`NewConstruction`,`NewConstructionDesc`,`NoOfGarageCap`,`OvenType`,`PoolPrivate`,`PoolPrivateDesc`,`Range`,`RangeType`,`Refrigerator`,`Roof`,`SchoolDistrict`,`SchoolElementary`,`SchoolHigh`,`SchoolMiddle`,`ShowInstructions`,`SqFtSource`,`Stories`,`Style`,`Subdivision`,`TaxAmount`,`TaxRate`,`WaterSewer`,`YearBuilt`,`YearBuiltSrc`) VALUES ('1','216074942','1675103685','216074942','2023-01-04T19:46:56.967','27742923','Matthew Guzman','RE/MAX Universal','','','29.453035','-95.298360','6','77511','10','416250.00','Active','Malbec','23523','Drive','Alvin','2','1','4','2558','Single-Family','CLICK ON SAMPLE 3D INTERACTIVE VIRTUAL TOUR!!! Welcome home to your beautiful Haydock floor plan with 4 Bedroom, 2 1/2 Bath, with a 2 Car Garage. Spacious OPEN CONCEPT FLOOR PLAN with high ceilings and the Family Room, Kitchen, Breakfast Room, Formal Dining Room, and the Master Bedroom downstairs. Upstairs you will find a Game Room, 3 Bedrooms and a Flex Space. You will love the Kitchen with the plenty of cabinets and granite countertops with stainless steel appliances, and even a USB outlet. Don\'t miss all the recessed lighting throughout the home. Covered PATIO with fenced backyard. COST AND ENERGY EFFICIENCY FEATURES: 16 Seer HVAC System, Honeywell Thermostat, Pex Hot & Cold Water Lines, Rheem® Whole House Tankless Gas Water Heater, Radiant Barrier, and Low E Windows that open to the inside of the home for cleaning. Martha’s Vineyard will offer residents two large lakes, playgrounds, and splash pad. Alvin ISD. Convenient to Hwy. 6, Hwy 288, and Beltway 8.','0.1791','5','Anglia Homes','','Electric Dryer Connections,Washer Connections','','Mud,Other Disclosures','1','','','Alvin North','Central Gas','1','MARTHA\'S VINEYARD SEC 3 (A0230 HT&BRR) BLK 1 LOT 15','Subdivision Lot','7802','Appraisal District','','550','1','To Be Built/Under Construction','3','Gas Oven','0','','','Gas Range','','Composition','3 - Alvin','HOOD-CASE ELEMENTARY SCHOOL','ALVIN HIGH SCHOOL','G W HARBY J H','Appointment Required,Leave Business Card','Builder','2','Traditional','Martha\'s Vineyard','1987','3.7074','Public Sewer,Public Water,Water District','2022','Builder'); --> New record created successfully